Changing Date from XX.XX.XXXX to XX/XX/XXXX for a column of dates

**pmarsella** · 08-05-2009, 03:30 AM

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!

**DonkeyOte** · 08-05-2009, 03:36 AM

Why not run an Edit -> Replace on the data replacing: . with : /

(record yourself doing it if you prefer a Macro based routine)

**arthurbr** · 08-05-2009, 04:21 AM

Another possibility : Data - text to columns - delimited - Next - Next Check DMY ( in Format) OK

**arthurbr** · 08-06-2009, 03:02 PM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save