View Single Post
  #5   Report Post  
Myrna Larson
 
Posts: n/a
Default

Do you mean that you want it to show 139 in this case? Or 139.7? If you don't
want it to round, you shouldn't set a format with a specific number of decimal
places.


On Tue, 11 Jan 2005 21:25:04 -0800, "Jmadden"
wrote:

I am doing come calculations and end up with 139.7 for example. If I format
the cell as a number with no decmial points it automatically rounds up to
140. Normally this is ok, but in this case I don't wnat it to round. Can I
turn the rounding feature off?