How can I keep my number from rounding up in a cell?

Ann Foley · 02/28/20

Hi,

I think this is probably and easy answer but I can't seem to figure it out. I want to type in 2.25 in a cell, for example, and it's rounding up to 2.3 - which I don't want. How can I get my numbers to remain exact?

Thanks!

Ann Foley · 02/28/20

Nevermind, figured it out.

Ann Foley · 02/28/20

Nevermind, figured it out.

Genevieve P. · 03/01/20

Hi Ann,

Glad you got it sorted! Let us know if you have any other questions.

Cheers,

Genevieve

Constantin Hapau · 12/08/21

HI , how do i stop the auto round up of decimal numbers and results in my cells please

Genevieve P. · 12/08/21

Hi @Constantin Hapau

Highlight the column by clicking on the column name, then you can apply decimal formatting from the formatting tool bar up at the top:

Screen Shot 2021-12-08 at 2.51.33 PM.png

See: Formatting Options

Cheers,

Genevieve

How can I keep my number from rounding up in a cell?

Best Answer

Answers

Categories