If you multiply a number by 1.02, that "is" adding 2% to the original
amount, as 1.02 is what you get when you add 2% to the number 1.
Why don't you try Mike's suggestion, and see what numbers you get?

If you are still struggling, give us some examples of:
What number you started with,
What operations you applied to that number,
What result you got,
What number you expected.
--
David Biddulph

"Lin242" wrote in message
...
I really appreciate your time, but even putting 1.02 in an empty box and
following the instructions you gave simply gives the actual percentage
amount, it doesn't ADD it to the existing numbers which is what I really
want
to do.

I will try your way tomorrow Jacinthe, I am not a regular Excel user, so
the
original instructions from Don made no sense to me. I'll see if yours are
a
bit clearer. It's frustrating because it appears like it should be so
simple
and it isn't. :)
--
Lin242


"Jacinthe" wrote:

Possibly the simplest solution. Except that OP specified that she wants
all
future entries to do this automatically. This solution would only fix
current entries.

"Mike H" wrote:

Lyn,

Put 1.02 in a cell and copy it. Select your range then

Edit|Paste Special
Select Multiply
Click OK

Mike