[SOLVED] once you have an amount in a cell how do you get that amount to i.

How do you get an amount already in a cell that had been formatted to
increase by say 500

Place 500 in a blank cell, edit|copy the cell with 500, edit|past
special|add on the cell you want to change



"jillingore" wrote:

> How do you get an amount already in a cell that had been formatted to
> increase by say 500

Jill,

You can add 500 to a cell by typing 500 in a blank cell, copying that cell,
then selecting your cell that you want to increment and: right-click, select
Paste Special, then click "Values" and "Add" and then press OK. You can do
this to multiple cells instead of just one.

Or, if you have a value in a cell, you can press F2, type +500, then select
everything in the cell and press F9. If you have a formula, press F2, then
type + 500 and press Enter.

HTH,
Bernie
MS Excel MVP


"jillingore" <jillingore@discussions.microsoft.com> wrote in message
news:47C1E1B0-021D-4B09-8B93-A1406FC5CEF3@microsoft.com...
> How do you get an amount already in a cell that had been formatted to
> increase by say 500

Hi Bernie

What does clicking Values do? I use the paste special Add or Multiply all the
time and never had changed All to Values in the top section.



"Bernie Deitrick" <deitbe @ consumer dot org> wrote in message
news:%23mOf3oaRFHA.1564@TK2MSFTNGP09.phx.gbl...
: Jill,
:
: You can add 500 to a cell by typing 500 in a blank cell, copying that cell,
: then selecting your cell that you want to increment and: right-click, select
: Paste Special, then click "Values" and "Add" and then press OK. You can do
: this to multiple cells instead of just one.
:
: Or, if you have a value in a cell, you can press F2, type +500, then select
: everything in the cell and press F9. If you have a formula, press F2, then
: type + 500 and press Enter.
:
: HTH,
: Bernie
: MS Excel MVP
:
:
: "jillingore" <jillingore@discussions.microsoft.com> wrote in message
: news:47C1E1B0-021D-4B09-8B93-A1406FC5CEF3@microsoft.com...
: > How do you get an amount already in a cell that had been formatted to
: > increase by say 500
:
:

Lady Layla,

> What does clicking Values do?

Keeps you from pasting (or overwriting existing) colors, conditional
formats, comments, borders....

HTH,
Bernie
MS Excel MVP


"Lady Layla" <nospam@nowhere.now> wrote in message
news:%23ypT60mRFHA.3628@TK2MSFTNGP12.phx.gbl...
> Hi Bernie
>
> What does clicking Values do? I use the paste special Add or Multiply all
the
> time and never had changed All to Values in the top section.
>
>
>
> "Bernie Deitrick" <deitbe @ consumer dot org> wrote in message
> news:%23mOf3oaRFHA.1564@TK2MSFTNGP09.phx.gbl...
> : Jill,
> :
> : You can add 500 to a cell by typing 500 in a blank cell, copying that
cell,
> : then selecting your cell that you want to increment and: right-click,
select
> : Paste Special, then click "Values" and "Add" and then press OK. You can
do
> : this to multiple cells instead of just one.
> :
> : Or, if you have a value in a cell, you can press F2, type +500, then
select
> : everything in the cell and press F9. If you have a formula, press F2,
then
> : type + 500 and press Enter.
> :
> : HTH,
> : Bernie
> : MS Excel MVP
> :
> :
> : "jillingore" <jillingore@discussions.microsoft.com> wrote in message
> : news:47C1E1B0-021D-4B09-8B93-A1406FC5CEF3@microsoft.com...
> : > How do you get an amount already in a cell that had been formatted to
> : > increase by say 500
> :
> :
>
>