How to round values from formulas to whole dollars
 

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

How to round values from formulas to whole dollars
 

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

On Apr 30, 6:50*pm, p2andr wrote:
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