Hi,
I have a list of dates formatted such as 17.06.2009 which excel does not read as a date. I need it to be converted to a date such as 17/06/2009 automatically (preferably using a macro).
The correctly formatted date must replace the cell it was originally in. Multiple rows of dates exist.
Any ideas?! Thanks!
Ps. Dont let me get fired!
Bookmarks