Shamsuddeen
Active Member
- Joined
- Feb 16, 2002
- Messages
- 292
Hi all!
In my worksheet, A1 houses the date in text format. eg. 31.03.2004 which I want to convert to Date format by using VBA.
The following formula does the same without macro
B1= =date(right(A1,4),mid(A1,4,2),left(A1,2))
When I tried the above formula in macro it did not work. So please help me to get something like:
[B1] = ?????? (A1)
Regards,
Shamsuddeen
In my worksheet, A1 houses the date in text format. eg. 31.03.2004 which I want to convert to Date format by using VBA.
The following formula does the same without macro
B1= =date(right(A1,4),mid(A1,4,2),left(A1,2))
When I tried the above formula in macro it did not work. So please help me to get something like:
[B1] = ?????? (A1)
Regards,
Shamsuddeen