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

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

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.

Alwayspop back and let us know the outcome - thanks

message edited by Derek

Ask Your Question

Weekly Poll

Did you watch the X-Files when it was on TV?

Discuss in The Lounge

Poll History