Reading from CSV date format

[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

 

[Guest]

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.

 

[Guest]

Thanks
I'll try those out

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.