How do I get excel to stop rounding numbers
 

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

How do I get excel to stop rounding numbers
 

One way:

=TRUNC(formula,1)

--

HTH,

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

"Brian" wrote in message
...
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?
--
Brian

How do I get excel to stop rounding numbers
 

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

"Brian" wrote:

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

How do I get excel to stop rounding numbers
 

--
Brian


"Brian" wrote:

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