Date conversion issue

  • Thread starter Thread starter GKW in GA
  • Start date Start date
G

GKW in GA

I have copied a file from another computer to Excel in CSV format. the source
computer has the date in the format 07/11/13 (it's actually 2007/11/13) and
it is displaying in Excel as 7/11/2013. If I go into Excel and change the
format of the cell to yyyy/mm/dd format it changes it to 2013/07/11 which is
still wrong.

How do I get 7/11/13 to display as 2007/11/13
 
Because its CSV, Excel "thinks" it knows how to interpret the value. Just
rename the file to something other than CSV. This will casue the Import
Wizard to be invoked. You can then tell the Wizard how to interpret the
value correctly.
 
Another way of invoking the wizard, without renaming the file, is to use
Data/ Import External Data, from within Excel, rather than just opening the
CSV file.
 
Back
Top