How do I convert every cell in a spreadsheet to round to millions

H

How2round

The numerical data in my spreadsheet currently rounds to the nearest whole
number. I would like to change all the cells to be rounded to the thousands
position. For example, 13,700,800 should be changed to 13,701. Is there a
way to do this to "groups of cells" by highlighting the appropriate cells and
adjusting them? Using the "Round" command seems to be limited to a single
cell; we have tons of data that require reformatting and applying this to
each individual cells is an undesirable choice.
 
B

bj

If you really want to do it to the entire workbook
enter 1000 in a cell
copy
select all the data you want converted
paste special - divide
<tools><options><Calculation>
select "precision as displayed"
enter 1000 in a cell again
copy
select data again
paste special multiple

I would quickly get rid of the precision as displayed selection.
 
R

raven_guy

I know that if you use the format key... U can go under the currency or
numerical tab and create the expression how you want it... or even decide how
many decimal places you want have. Hope this helps.

Ron
 
C

cscorp

Hi,

Try using this custom format : #,###,

Highligh the cells you want to apply the format, then:

Format > Cells > Numbers Tab > Custom --> Enter the format in the
"Type" texbox as shown in the pic.

Hope it helps!

Juan Carlos


+-------------------------------------------------------------------+
|Filename: Thousands .jpg |
|Download: http://www.excelforum.com/attachment.php?postid=3468 |
+-------------------------------------------------------------------+
 
Top