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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting Dates 4
Convert european foreign date format to US date format 2
converting dd/mm/yy to mm/dd/yyyy 3
Excel is seeing the date as dd/mm/yyyy 4
Converting mm/dd/yyyy to yyyy/mm/dd 6
convert 13.11.2009 general to 13/11/2009 date, how to 1
convert date mm/dd/yyyy to dd/mm/yyyy 2
how do I change the date format from yyyymmdd to mm/dd/yyyy 4

Back
Top