PREVENT conversion of text to number?

C

celticvalley

I have a CSV file that I will open (or import) and which has one colum
that contains serial numbers. The problem is that some of the number
have this format: 123E567.

Excel promptly converts this text to a number: 1.23E+569. Even if
then change the format of the cell to text, it still keep the tex
1.23E+569.

How can I either prevent the original text from being converted t
begin with or how can I correct it after the fact?

Best regards,
Ke
 
D

Dave Peterson

Change the name of the file from .csv to .txt.

Then when you do file|open, you'll see text to columns wizard pop up. You'll be
able to specify each field--including this one as Text.
 

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

Reading CSV with numbers in text format, Excel automatically convertsto scientific notation 1
Working with mac addresses 3
Number in text format in CSV file 3
Convert Numbers stored as Text to Numbers 2
Disable conversion from text to number from .csv file 2
how to resolve incompatibility of saving an excel to csv format 1
in 2003 i have 0 text file conrt to 2007 number 1
Format appears stuck..how to break formatting 2

Top