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" wrote in message
...
How do you get an amount already in a cell that had been formatted to
increase by say 500