View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete
 
Posts: n/a
Default Question about decimal places

In the cell that produces $11.85983733333 by some formula, you should
modify this to:

=ROUND(your_formula,2),

although I would have thought this would produce $11.86 - if you really
want $11.85, use:

=ROUNDDOWN(your_formula,2), or
=INT(your_formula*100)/100

Hope this helps.

Pete