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
Microsoft ExcelMicrosoft OfficeSpreadsheets

Avatar of undefined
Last Comment
Rory Archibald

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Rory Archibald

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes