A "ROUND"-about way...........
First, do a Find&Replace to delete all your equal signs from the formulas in
the range you wish to change.
Then, well off to the side, put this formula in a same-row cell and copy
around to cover the range you have.
="@ROUND("&C4&",-3" This will give you a TEXT representation of the
formula you're after. Then, Copy PasteSpecial Values that TEXT
"formula" back to it's original location.........then just Find and Repalce
the @ with an equal sign........there you are............

Vaya con Dios,
Chuck, CABGx3






"Ellemarr" wrote in message
...
I have a large worksheet full of formulas which all need to be rounded to
the
nearest thousand. Without adding the "ROUND" command to every formula
individually (which would take forever) is there a way to apply rounding
to a
whole range?