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

Ann Foley

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

Nevermind, figured it out.

Ann Foley

Nevermind, figured it out.

Genevieve P.

Hi Ann,

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

Cheers,

Genevieve

Constantin Hapau

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

Genevieve P.

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:

See: Formatting Options

Cheers,

Genevieve