That worked - really easy, but I've never used that function before.
Thanks a lot!!!!!!!!!!


"Niek Otten" wrote:

In an empty cell enter the formula

=1.05

Not just the number 1.05!

Edit|Copy

Select your formulas

Edit|Paste Special, check Multiply

Try on a copy if your workbook first

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"karin Harpering" <karin wrote in message
...
|I am trying to update a lot of formulas on a worksheet with the same factor,
| but I'm not sure if I have to update each and every formula, or if there is
| some way of doing a mass update in formulas? The normal find/replace doesn't
| seem to work!