Hi,

Tip: You can use Names or labels

You can do one of the following:

On the Insert menu, point to Name and click Define and create a Named
definiton for totals.

-or-

On the Insert menu, point to Name and click label definiton a label.

In either cases you canjust change the value in the cell and the lable would
take care. You need have to change or edit formula.

For more information, refer to the following topics in the Microsoft Excel
2003 on-line help:

About labels and names in formulas

Challa Prabhu

"SenorSteve" wrote:

I have a sheet that contains various functions which is updated
regularly. The problem is, when updating, the formula never needs to
be changed, only the number. I know it is possible to simply edit the
number in the formula bar, but I was wondering if there was a way to
"append" a formula to a certain cell, allowing the user to simply type
in the number as they would a regular cell and not have to worry about
altering the formula.


Is this possible, or is it necessary to edit the number via the
formula bar each time?