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

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

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

Best regards,
Ken


--
celticvalley
------------------------------------------------------------------------
celticvalley's Profile: http://www.excelforum.com/member.php...o&userid=26360
View this thread: http://www.excelforum.com/showthread...hreadid=396287

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.



celticvalley wrote:

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

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

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

Best regards,
Ken

--
celticvalley
------------------------------------------------------------------------
celticvalley's Profile: http://www.excelforum.com/member.php...o&userid=26360
View this thread: http://www.excelforum.com/showthread...hreadid=396287

--

Dave Peterson

Thank you very much, Dave. This worked great.

Have a nice day.
Ken


--
celticvalley
------------------------------------------------------------------------
celticvalley's Profile: http://www.excelforum.com/member.php...o&userid=26360
View this thread: http://www.excelforum.com/showthread...hreadid=396287