Incoorrect date formats in Excel 2000

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

Guest

H

I'm inporting a .txt file into excel. Some of the dates are coming across correctly i.e. DD/MM/YYYY however some come through in a different format (MM/DD/YYYY). I've checked the format of the cell and it's the same as the cells that are working correctly. I've even tried a paste special and just pasted the format but it doesn't seem to change anything. Any idea's would be appreciated!!
 
If it's a .txt file, don't you get the import wizard to open up?

And then you can specify the correct format for each field--including mdy or
dmy.
 

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

Excel 2002: How to make the date format uniform ? 1
Date Formats 1
Convert dates stored as text 2
date 1
Change of date format when syncing Excel 2007 to Excel Mobilw 8
Date automatically swaps 6
Date format changes in mail merge using Excel worksheet as data 2
Date Format 2

Back
Top