Arghhhh! 1-4375 in a text formated cell changes to 1/01/4375 in saved csv file

  • Thread starter Thread starter BoredSilly
  • Start date Start date
B

BoredSilly

help!

I am obviously got something wrong. What do i have to do to save 1-4375 as
1-4375 in a csv file? I have all auto correct options turned off and the
column formatted as text and yet it still converts it to 1/01/4375 and
displays as Jan-75 when i load the csv file.

Regards

BoredSilly
 
Change the file extension to .txt
Then, when you open the file, the Import Wizard will appear.
In step two, choose the comma delimiter
In step three, in the Data Preview, select the column with the 1-4375,
and set the Column data format to text.
Click Finish, and the data should be imported without converting to dates
 
Back
Top