How do I get excel to stop rounding numbers

B

Brian

In calculating a differential for a golf handicapp index, the formula is to
calculate to the first decimal place and do not round. How do I turn off the
rounding?
 
R

RagDyeR

One way:

=TRUNC(formula,1)

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

In calculating a differential for a golf handicapp index, the formula is to
calculate to the first decimal place and do not round. How do I turn off the
rounding?
 
A

Art

Also your problem might be the formatting that you're looking at. Check and
make sure that you can see enough decimals.
 
Top