View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
myssieh myssieh is offline
external usenet poster
 
Posts: 15
Default Cells Rounding up but shouldn't be

Good Morning!!

I am running Excel 2003..

I have a group of cells that are being added together and excel is rounding
them up by .01...

Cell D3=$879.56
Cell D4=56000.10
Cell D5=$4173.17
Cell D6=$0.00
Cell D7 is a sum of the above and it shows $61052.84. When you manually
calculate these fields it shows $61052.83.

There is no formula on the cell that tells it to do this...

What could be causing this and/or how can I prevent it?

Thanks in advance!!

Myssie