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!!!!