Rounding

[Guest]

How do I format a cell so a calcuated # is a true whole # (ie 4) for additional formulas, not just appearing as a whole # (4.43560 appearing as 4)?

 

[J.E. McGimpsey]

Formatting doesn't change the value stored in a cell, unless you
have checked the Tools/Options/Calculation Precisions as displayed
checkbox (which applies to the entire workbook).

You can instead wrap your calculation in the ROUND() function:

=ROUND(<your existing formula>,0)

 

[Bob Umlas]

A formatted cell and its contents are not at all the same. You can't do what
you want by formatting, you need a formula, like =ROUND(MyCell,0) or
=INT(MyCell)
Another thing you can do which DOES take formatting into account is to use
Tools/Options/Calculation, and check the box "Precision as displayed".

Bob Umlas
Excel MVP

How do I format a cell so a calcuated # is a true whole # (ie 4) for

additional formulas, not just appearing as a whole # (4.43560 appearing as
4)?

 

[Peo Sjoblom]

=ROUND(number,0)

--

Regards,

Peo Sjoblom

How do I format a cell so a calcuated # is a true whole # (ie 4) for

additional formulas, not just appearing as a whole # (4.43560 appearing as
4)?