MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Rounding Formula or Macro

Posted by Tim Johnson on November 19, 2001 7:14 AM

I NEED help with the rounding formula or possibly a macro. The problem arises when I have formulas set up and the spreadsheet will not always foot when you simply show the dollar amounts with no decimal places. I need a macro to round all of the formula cells at the same time to zero decimals (whole dollars), while keeping the formula in the cell in tact. Can this be done? THANKS SO MUCH IN ADVANCE!!!!

Posted by IML on November 19, 2001 7:21 AM

Try selecting "precision as displayed" under tools option calculation. If you add 1.49 plus 2.49 you get 3 when its set to show no decimal places.

Posted by Mark W. on November 19, 2001 7:23 AM

Using the Tools | Options... menu command select
the "Precision as displayed" checkbox on the
"Calculation" tab. Format your currency values
without a decimal place (e.g., $0 or $#,##0).