Enter the multiplier in an unused cell then highlight the range that you
want to update and the right-click and select Paste Special, (or select Edit
Paste Special), then select Multiply

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Dave" wrote in message
...
I'm creating a spreadsheet for work, and I would like to use one
multiplier
throughtout the entire spreadsheet, instead of having to enter repeatedly
putting in the same forumula over and over again.. the cells contain
different numbers but the multiplier will always be the same.