How to round values from formulas to whole dollars

[p2andr]

I am copying over many formulas that are not formatted as round(,0) and when
I copy/paste special I want the result to be whole numbers only. But not
just on the display but in the actual cell.

Thanks

Robin

 

[Pete_UK]

If the cells are formatted as you wish them (i.e. displaying numbers
with no decimal places, then you can click on Tools | Options |
Calculation tab, then check Precision as Displayed. Excel will give
you a warning, but if you click OK then those numbers will be changed
to match the display. It might be a good idea to change the setting
back, and to use File | Save As to give the file a different name, so
that you can always get back to the original if you need to.

Hope this helps.

Pete