Microsoft Excel - Hi Everybody - Asked By sam spatafora on 05-Feb-13 11:58 AM

Hi Everybody

I have an annoying problem in my Excel 2003. I will enter numbers like $53.34, $2.70 etc then after I go to the next cell the numbers will automatically go the next highest dollar $53.34 to $54.00 and $2.70 to $3.00 etc.

And then when I add totals in a column the total will also go to the next highest dollar.

 Is there any way to stop this function this?

Thank You

 

Donald Ross replied to sam spatafora on 05-Feb-13 08:43 PM
check to make sure you are not using percision rounding to round to the nearest whole dollar and formatting the cell to currency.

Don
sam spatafora replied to Donald Ross on 07-Feb-13 05:04 PM

 make sure you are not using percision rounding to round to the nearest whole dollar and formatting the cell to currency.

Thank you for your reply. 

Being a novice what dou mean by make sure you are not using percision rounding to round to the nearest whole dollar and formatting the cell to currency ? 

How do I  check for this and how do I turn it off and eliminate this nuisance?

thank you