You can just use formatting to visually round what you are seeing, and if
you have other formulas that refer to that whole range, then you can adjust
those to round the data that they are getting from that range. Give us some
more detail and we can be a bit more specific.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"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