Increase numbers in cells

[Guest]

One of my co-workers wants to increase the numbers in each cell by 10, 100 or
1,000.

Is there a way to do this without going through and changing each and every
cells. I was thinking about putting those values in a cell and then putting a
formula in the cell to multiply the value of that cell by that value. But
then that would require putting those values in a different area as well.

Thanks for the help!

 

[Anne Troy]

Here you go, Larry:
http://www.officearticles.com/excel...up_of_cells_in_microsoft_excel_worksheets.htm
Hope it helps!
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

 

[Guest]

enter the 10, 100 or 1000 in a cell and copy it,
select the cells you want to increase and <paste special> and select
multiply or add
(I am not sure which you want to do)