divide all cells in column by 1000000

K

kf

What is the fastest way to convert ALL the cells in a
column by a number (1000000 in this case)?

I have too many rows to even think about doing it manually.

Would really appreciate any input!

Thanks!
 
P

Paul B

KF, put 1000000 in a cell then click on it and copy, then select the range
you want to change and right click and paste special, under operations pick
divide click OK.

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
 
K

kf

Thanks Paul... I guess I should read up on all the
enhancements since Excel '97!! Thanks again!!
 
K

King

If it's only for display purposes, using the custom format and putting
two commas after your format will display in millions.

#,###,,

or

#,###.0,,
 
Top