How to round all numbers in a worksheet to, say 1,000s?
 

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

How to round all numbers in a worksheet to, say 1,000s?
 

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?

How to round all numbers in a worksheet to, say 1,000s?
 

If you do that, you can round them by choosing Tools/Options/Calculation
and checking the Precision as displayed checkbox.

After the conversion, you can uncheck that checkbox and reformat if
desired.

In article ,
"Tom Ogilvy" wrote:

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

#,###,