keeping 0s after decimal

Arijose · Apr 28th, 2002, 02:36 PM

I am trying to export a comma delimited xls file with numbers containing decimals in each cel. Excel seems to drop the zeros after decimals though. This is a problem because these are part numbers. Please help.

Ari

Jay Petrulis · Apr 28th, 2002, 02:58 PM

Hi,

Are you importing or exporting the file?

If you are importing the file, try to import the column(s) in question as text--the wizard will allow you to indicate how you want each column to be imported.

If you are exporting, make sure that these columns are text and the export should maintain the zero values.

HTH,
Jay

Arijose · Apr 28th, 2002, 03:04 PM

I am exporting the file through a script as filename.xls . ex:
cel1, cel2, 1000.00, cel4

The ".00" in "cel3" are lost when viewing file.

Thanks,
Ari

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

Apr 28th, 2002, 02:36 PM	#1
Arijose New Member Join Date: Apr 2002 Location: Arizona Posts: 2	I am trying to export a comma delimited xls file with numbers containing decimals in each cel. Excel seems to drop the zeros after decimals though. This is a problem because these are part numbers. Please help. Ari

Apr 28th, 2002, 02:58 PM	#2
Jay Petrulis MrExcel MVP Join Date: Mar 2002 Location: Chicago, IL USA Posts: 2,042	Hi, Are you importing or exporting the file? If you are importing the file, try to import the column(s) in question as text--the wizard will allow you to indicate how you want each column to be imported. If you are exporting, make sure that these columns are text and the export should maintain the zero values. HTH, Jay

Apr 28th, 2002, 03:04 PM	#3
Arijose New Member Join Date: Apr 2002 Location: Arizona Posts: 2	I am exporting the file through a script as filename.xls . ex: cel1, cel2, 1000.00, cel4 The ".00" in "cel3" are lost when viewing file. Thanks, Ari