Trice
New Member
Longtime Excel user, and I upgraded to the 2019 version about three months ago. I've noticed recently that, at least for older spreadsheets, Excel automatically adds two decimal places to certain cells when I click into the formula bar. These cells are already formatted to show currency with no decimal places. But when I click in the formula bar then hit return, it adds two decimal places. The values in the cell (and from the cells the formula references) do include cents - they are not whole numbers - but I've specifically set the formatting to show whole dollar values only.
Even when I re-format the cell for currency with no decimal places, this auto-reformatting behavior continues. As far as I can tell from my testing, this behavior does not happen with new sheets I create in 2019.
(Under Options > Advanced > Editing Options > the "Automatically insert a decimal point" box is UNchecked. I even turned it on, set the "places" value to 0 then turned it back off again and the behavior persists.)
Edit: From my testing it appears this behavior only happens in cells with formulas, not cells that contain only data. I entered data with two decimals but still formatted not to show decimals, and the formatting held even when I clicked in and out of the formula numerous times.
Any ideas?
Even when I re-format the cell for currency with no decimal places, this auto-reformatting behavior continues. As far as I can tell from my testing, this behavior does not happen with new sheets I create in 2019.
(Under Options > Advanced > Editing Options > the "Automatically insert a decimal point" box is UNchecked. I even turned it on, set the "places" value to 0 then turned it back off again and the behavior persists.)
Edit: From my testing it appears this behavior only happens in cells with formulas, not cells that contain only data. I entered data with two decimals but still formatted not to show decimals, and the formatting held even when I clicked in and out of the formula numerous times.
Any ideas?
Last edited: