If you just want them to look rounded then format the cells using a custom
number format like:

#,###,

--
Regards,
Tom Ogilvy


"JCMKM" wrote in message
...
How to round all numbers in a worksheet to, say 1,000s, instead of typing
the
=round(n,-3) over and over?