Reading from CSV date format

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

Guest

Hi there,

When I read from my CSV file the date column is in DD MM YY - its a string
in the CSV file (with quotes). However when it comes into excel is MM DD YY.

How do I stop this conversion from happening automatically.

Any help greatly apprecaited

Thanks

Suzanne
 
there arre two solutions.

1) Make the cells in excel text before importing the CSV
2) Importing CSV allow you to select cell formats.
In Import menu - select file
a) first window use default delimited
b) second window uncheck tab and select comma
c) third window allos you to select formating.
 
Thanks
I'll try those out

Joel said:
there arre two solutions.

1) Make the cells in excel text before importing the CSV
2) Importing CSV allow you to select cell formats.
In Import menu - select file
a) first window use default delimited
b) second window uncheck tab and select comma
c) third window allos you to select formating.
Click to expand...
 
Back
Top