divide all cells in column by 1000000

  • Thread starter Thread starter kf
  • Start date Start date
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!
 
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 **
 
Thanks Paul... I guess I should read up on all the
enhancements since Excel '97!! Thanks again!!
 
If it's only for display purposes, using the custom format and putting
two commas after your format will display in millions.

#,###,,

or

#,###.0,,
 
Back
Top