Decimals auto added to formatted cells..??

[AlisaA]

I am having a problem where Excel 2013 is automatically adding 2 decimal places to cells that I have formatted to NOT show decimals. The decimals show up whenever I type a formula using a percentage into either that cell or into a cell near it. It appears to be random when this actually happens.

I have gone through Excel options and deselected Automatically insert a decimal point, Extend data range formats and formulas, Enable automatic percent entry, and Use system separators. None of these have made a difference.

Is there something else I need to do to make this stop? Thank you for your help!

 

[joeu2004]

I am having a problem where Excel 2013 is automatically adding 2 decimal places to cells that I have formatted to NOT show decimals. The decimals show up whenever I type a formula using a percentage into either that cell or into a cell near it. [....] Is there something else I need to do to make this stop?

I'm afraid the answers is: probably not. The problem has existed since Excel 2003, AFAIK; perhaps "forever". I see the problem myself frequently; and like you, it irks me to no end. But we just have to put up with it.

God, grant me the serenity to accept the things I cannot change,
Courage to change the things I can,
And wisdom to know the difference.
-- Reinhold Niebuhr