View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default 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