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!
Best Answer
-
Nevermind, figured it out.
Answers
-
Nevermind, figured it out.
-
Hi Ann,
Glad you got it sorted! Let us know if you have any other questions.
Cheers,
Genevieve
-
HI , how do i stop the auto round up of decimal numbers and results in my cells please
-
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