How to divide the collection of data at once in Excel

How to divide the collection of data at once in Excel
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. If you guys have any of the information of or any of the ideas for this then please let me know.
Reply With Quote
#2
Old 14-01-2012
Gania Gania is offline
Member

Join Date: Nov 2010
Posts: 480
Re: How to divide the collection of data at once in Excel
According to my information 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. This is one of the Better methods for doing this. Custom Format to #, ###,

If you like this post then consider sharing it with others.