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
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" <[email protected]> wrote in message
news:[email protected]...
>
> 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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks