Date Conversion dd.mm.yyyy to dd/mm/yyyy
 

Hi,

I have a proprietary program which exports date time values to a text file
in this format dd.mm.yyyy and i would like to be able to work with these
values in excel, but of course excel likes dates to be in dd/mm/yyyy format.

Any ideas on how to go about converting them?

Scott

Date Conversion dd.mm.yyyy to dd/mm/yyyy
 

Select your range of dates
Goto the menu EditReplace
Find what: . (enter a period)
Replace with: /
Replace all
Close

Now, if you're OS settings for date are English (U.S.) then the default date
format is m/d/yyyy. After doing the EditReplace the dates are still TEXT
strings. To convert them to real dates:

Select the range of dates
Goto the menu DataText to Columns
Click NEXT twice
In step 3 of the wizard under Column data format select DateMDY
Finish

--
Biff
Microsoft Excel MVP


"ScottRA" wrote in message
...
Hi,

I have a proprietary program which exports date time values to a text file
in this format dd.mm.yyyy and i would like to be able to work with these
values in excel, but of course excel likes dates to be in dd/mm/yyyy
format.

Any ideas on how to go about converting them?

Scott