View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
m2222 m2222 is offline
external usenet poster
 
Posts: 1
Default how to divide a numbers in a table of data by 1,000, all at once

I've noticed in some spreadsheets that numbers are displayed as
rounded...i.e. so that one isn't looking at 1,403,333 + 2,333,999 etc. but
rather 1403 + 2334, etc. with a note at the top that says "000's".

In one step, how can I edit all the numbers in a table so that they show to
the nearest 10,000 (i.e. 1403 +2334), without dividing them one by one by
1,000?

Or, to go at it from another angle, how do I divide each # by 1,000?

The ROUND feature requires that I create a new table. Not exactly what I'm
looking for.