EEuser5551212

asked on

# retaining lost decimal places when saving from .xls to .csv

I am running Excel 2000 SP# on XP Pro SP3.

Please look at example1.xls.

Column A has a bunch of integers.

Column B is the same numbers with the following formatting: Format--Cells--Number tab--Number--2 decimal places.

Example1.xls is then saved as a .csv file - example1.csv.

However, when example1.csv is opened with Excel, column B loses the 2 decimal places.

How can I retain the 2 decimal places when opening example1.csv in Excel?

example1.xls

example1.csv

Please look at example1.xls.

Column A has a bunch of integers.

Column B is the same numbers with the following formatting: Format--Cells--Number tab--Number--2 decimal places.

Example1.xls is then saved as a .csv file - example1.csv.

However, when example1.csv is opened with Excel, column B loses the 2 decimal places.

How can I retain the 2 decimal places when opening example1.csv in Excel?

example1.xls

example1.csv

ASKER CERTIFIED SOLUTION

membership

Create an account to see this answer

Signing up is free. No credit card required.