csv file load

[vneskovic]

I am tring to load csv file into excel, and when ever the field contains <number> E<number>, excel presents it in
scientific format (eg, 9E9 -> 9.00E+09). Is there any way to avoid this ?

 

[Mark W.]

Change your file extension to .txt, use the Text to Columns wizard, and format the columns containing such values as Text.

 

[Al Chara]

Read the following thread:

http://www.mrexcel.com/board/viewtopic.php?topic=3300&forum=2

The answer is at the bottom from Dave Hawley

 

[Mark W.]

On 2002-04-10 07:04, Al Chara wrote:
Read the following thread:

http://www.mrexcel.com/board/viewtopic.php?topic=3300&forum=2

The answer is at the bottom from Dave Hawley

This only applies to XL2000 or later.
This message was edited by Mark W. on 2002-04-10 07:20