Solved Turn rounding feature off in Excel

August 1, 2013 at 11:45:44
Specs: Windows 7
My numbers always round how do I turn this function off in excel?

Various formulas in final numbers but it always rounds. I need to turn this function off in a particular wookbook


See More: Turn rounding feature off in Excel

Report •


#1
August 1, 2013 at 12:16:47
That's normal behavior if the cell is formatted for 2 places after the decimal point. How many numbers are entered after the decimal?

message edited by Jennifer SUMN


Report •

#2
August 1, 2013 at 12:44:04
✔ Best Answer
Note that the rounding is only presentation. The calculations are done with the full numbers. You can increase the number of places that are shown if you wish, using
Format > Cells. The maximum is 30.

EDIT: Added a bit more.

Always pop back and let us know the outcome - thanks

message edited by Derek


Report •

Related Solutions


Ask Question