View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default 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:

#,###,