Increase numbers in cells
 

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!

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

www.OfficeArticles.com
www.MyExpertsOnline.com


"Larry G." wrote in message
...
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!

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)
"Larry G." wrote:

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!