Hello All.
I try to deal with my problem but without any results. I wrote code:I try to get a date from a cell in format dd/mm/yyyy. But I have problem with pattern. Please provide me well pattern.Please Login or Register to view this content.
Hello All.
I try to deal with my problem but without any results. I wrote code:I try to get a date from a cell in format dd/mm/yyyy. But I have problem with pattern. Please provide me well pattern.Please Login or Register to view this content.
(*) Reputation points appreciated.
excelbs.tk
Try:
The Global property is set to False by default, so no need to include.Please Login or Register to view this content.
Cheers,
berlan
EDIT: added code sample, in addition to a RegEx pattern
Last edited by berlan; 07-15-2015 at 06:42 AM.
Berlan thank you for response but neither my nor your pattern doesn't work. Lets look at example of cell:Please Login or Register to view this content.
michson, with the revised DateFromCell function I posted above, this is the result I get
Row\Col A 1RNB 9/1/2015 21,036.67 1,945.59 29/1/2015
A2: =DateFromCell(A1)
Last edited by berlan; 07-15-2015 at 06:50 AM.
Berlan thank you very much. Appreciation point goes to you
My second question concerns how to get off rest of numbers like in example 21,036.67 and 1,945.59. I tried this code and pattern:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks