csv file load

vneskovic · Apr 10th, 2002, 07:47 AM

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

Mark W. · Apr 10th, 2002, 07:56 AM

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

Al Chara · Apr 10th, 2002, 08:04 AM

Read the following thread:

http://www.mrexcel.com/board/viewtop...c=3300&forum=2

The answer is at the bottom from Dave Hawley

Mark W. · Apr 10th, 2002, 08:17 AM

Quote:

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

http://www.mrexcel.com/board/viewtop...c=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 ]

Apr 10th, 2002, 08:04 AM	#3
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	Read the following thread: http://www.mrexcel.com/board/viewtop...c=3300&forum=2 The answer is at the bottom from Dave Hawley __________________ Kind regards, Al Chara

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 10th, 2002, 07:47 AM	#1
vneskovic New Member Join Date: Apr 2002 Posts: 1	I am tring to load csv file into excel, and when ever the field contains E, excel presents it in scientific format (eg, 9E9 -> 9.00E+09). Is there any way to avoid this ?

Apr 10th, 2002, 07:56 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Change your file extension to .txt, use the Text to Columns wizard, and format the columns containing such values as Text.