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

S

ScottRA

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
 
T

T. Valko

Select your range of dates
Goto the menu Edit>Replace
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 Edit>Replace the dates are still TEXT
strings. To convert them to real dates:

Select the range of dates
Goto the menu Data>Text to Columns
Click NEXT twice
In step 3 of the wizard under Column data format select Date>MDY
Finish
 
Top