Forum Discussion
Excel changing numbers, removes the decimal point.
I have a little spreadsheet I use to calculate gas mileage, costs, per tank and annually etc. Excel has decided to eliminate the decimal point in the number field for gas, so I type 12.215 and excel ...
Is that for any file or for some specific one? If the latest perhaps you may attach a sample.
SergeiBaklan See attached sheet. I highlighted the problem. Green cells are fine, yellow cells will not accept a decimal so instead of 12.215 gals, I get just the string 12215...argh. I have been keeping this file for years. Thanks for the help!
Mark, I'm not able to reproduce, all numbers are entered correctly (left column here)
At the same time, if inspect the document we see some extra XML data exists
Cleaned it in attached file, not sure how that could affect.
So far have no idea what it could be.
That's on initial file or one I attached? The latest is cleaned.
