Link to home
Create AccountLog in
Avatar of EEuser5551212
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
ASKER CERTIFIED SOLUTION
Avatar of Rory Archibald
Rory Archibald
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account