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

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
 
D

Debra Dalgleish

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
 

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

Losing leading 0 when saving as .csv 2
Text Output To CSV 5
time format- enter 25:01 it becomes 1:01 1
How to keep loaded file's format intact? 1
CSV file opening as a text format 1
Open CSV files without auto-formatting values 1
Hidden Formating Or Delimiters: Showing Of ? 2
problems when saving as comma delimited text file 1

Top