how to divide a numbers in a table of data by 1,000, all at once

  • Thread starter Thread starter m2222
  • Start date Start date
M

m2222

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.
 
Enter 1000 in an unused cell.

Copy that cell.

Select the range to change and edit>paste special>divide>ok>esc.

Delete the cell with 1000

Alternative for cell display only which shows 1,403 but leaves the original
value as 1403000..............better method in my mind.

Custom Format to #,###,


Gord Dibben MS Excel MVP
 
Back
Top