update all numbers in a column by a percentage

  • Thread starter Thread starter Dan Crowson
  • Start date Start date
D

Dan Crowson

Hello,

I want to update all of the numbers in a column by another
number. In other words, I'd like to add 10% to all the
prices. The only way I've found to do this is to copy the
data to another row and then do something like
+copiedcell*.10+copiedcell and then copy the results to
the old column. The problem is that I can't remove the
old data because they are now functions.

Is there any way to run a function over the original row
to do this?

Thanks,

Dan
 
If you have a set of prices without formulas and you want to add 10%, put
1.1 in an empty cell,
copy it, select the old prices, do edit>paste special and select multiply.If
they are formula you might be able
to do an edit>replace if you know what to replace. Otherwise you would need
VBA...
 
Peo,

your solution worked - thanks!

Dan
-----Original Message-----
If you have a set of prices without formulas and you want to add 10%, put
1.1 in an empty cell,
copy it, select the old prices, do edit>paste special and select multiply.If
they are formula you might be able
to do an edit>replace if you know what to replace. Otherwise you would need
VBA...

--

Regards,

Peo Sjoblom





.
Click to expand...
 
Back
Top