Rounding

  • Thread starter Thread starter Guest
  • Start date Start date
G

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)?
 
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)
 
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

jw said:
How do I format a cell so a calcuated # is a true whole # (ie 4) for
Click to expand...
additional formulas, not just appearing as a whole # (4.43560 appearing as
4)?
 
=ROUND(number,0)

--

Regards,

Peo Sjoblom

jw said:
How do I format a cell so a calcuated # is a true whole # (ie 4) for
Click to expand...
additional formulas, not just appearing as a whole # (4.43560 appearing as
4)?
 
Back
Top