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:
#,###,
|