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!