incrementing cost in excel???

[cerebro]

Hi, I have a list of wholesale prices for a range of products and I want to change the price to retail to sell through an ebusiness and was wondering if I could use excel to increment all the wholesale costs by say 20 without having to do each by hand. Is it possible to update all the prices with a few commands or am i going to have to change all 1000 of them by hand. thanks for any help.

[JE McGimpsey]

Enter 20 in a blank cell. Copy the cell. Select your prices. Choose
Edit/Paste Special, selecting the Values and Add radio buttons. Click OK.

In article <cerebro.26zh5d_1146243005.0671@excelforum-nospam.com>,
cerebro <cerebro.26zh5d_1146243005.0671@excelforum-nospam.com> wrote:

> Hi, I have a list of wholesale prices for a range of products and I want
> to change the price to retail to sell through an ebusiness and was
> wondering if I could use excel to increment all the wholesale costs by
> say 20 without having to do each by hand. Is it possible to update all
> the prices with a few commands or am i going to have to change all 1000
> of them by hand. thanks for any help.

[cerebro]

thank you very much for a quick response.