If you don't ger a "real" answer, you can always fake it by cutting and
pasteing them to another sheet, and then use a ROUND formula to reference
them in place of where they were, like
=ROUND(Sheet2!A1,-3) and copy around...........
hth
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?
|