Increase the value of as series of cells by 3%

Hi

I have a columb of values that I need to increse the value of by 3%. Is
there a way to select that columb and increase them?


Cheers Peter

"Peter" <inver@nospam.nz> wrote in message
news:OuygPKqWFHA.3584@TK2MSFTNGP14.phx.gbl...
>
> Hi
>
> I have a columb of values that I need to increse the value of by 3%.
> Is there a way to select that columb and increase them?
>
>
> Cheers Peter
>

Hi Peter,

First back up your file just in case.

Now, enter 1.03 in a spare empty cell somewhere, copy that cell,
select the range of cells to increase, and do:

Edit - Paste special

Select: Formula and Multiply

Click OK.


HTH,

Alan.