MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Repeating Tasks

Posted by Nick Laul on January 26, 2001 11:10 AM

I have a spreadsheet full of #s. These #s are in millions of $s. If I want to change all these #s from millions to thousands, is there an easy way to do it. Or in other words is there a one step way to select a bunch of cells and apply a function to all of them. Thanks

Posted by Mark W. on January 26, 2001 11:26 AM

If you just want to format the results as 000's then
apply a format of 0,

If you want to change the content of the cells from
000,000's to 000's then after applying the 0, format
you can change the precision of these values by check-
ing the Tools Options... Calculation "Precision as
displayed" check box...

Or you can forgo the format change altogther; type
1000 into an empty cell and copy it; select the
values you want changed; do a Paste Special... Values
with the "Divide" operation selected.

Posted by John S. on January 26, 2001 11:27 AM

select the range of numbers
click Format,Cells,Number,Custom and type in "0,#," excluding the quotes

Posted by Mark W. on January 26, 2001 12:41 PM

Oops! I just found time to double-check my
recommendation to change the value by checking
"Precision as displayed". Such a change only
applies to decimal places. You'll need to follow
my 2nd approach (using Paste Special... Values
with the Divide operation if you intend to change
the actual contents of the cells.