View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default rounding in excel

It won't round unless you tell it to. It may look like it rounds because it
is formatted to too few decimal places. Just increase the number if decimal
places in the format, maybe even use a format of 0.0#.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"textile1" wrote in message
...
When I do a formula in excel I don't want the result (which is 2 decimal
places) to round up or down. How do I turn off the rounding feature.

Thanks