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...
 

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

Date format error with CSV file 6
Finding Date in an overseas format 20
Date Format 2
Csv date format problem 2
International Date formatting 4
Date formatting 1
Vba Date$ 1
DateValue gets wrong date number 16

Back
Top