Reading from CSV date format
 

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

Reading from CSV date format
 

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.

"Grd" wrote:

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

Reading from CSV date format
 

Thanks
I'll try those out

"Joel" wrote:

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.

"Grd" wrote:

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