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

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.

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.

"How2round" wrote:

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.

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

"How2round" wrote:

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.

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 |
+-------------------------------------------------------------------+

--
cscorp
------------------------------------------------------------------------
cscorp's Profile: http://www.excelforum.com/member.php...o&userid=24015
View this thread: http://www.excelforum.com/showthread...hreadid=377456