You actually defined a name for that value (4685). Did you mean to do that or
did you mean to define a name for the cell that held that value?

insert|name|define
names in workbook: MyCell
Refers to: =Sheet1!$A$1

Then I could plop anything I wanted in A1 of sheet1 and refer to it by its name:

=mycell*3
(for example)

If I changed the contents of that "myCell", then all the formulas that depend on
that name will reevaluate.


acpharmd wrote:

I am still at a loss. I entered text into a cell, then, under the "insert"
menu, I selected name, define, and entered the value "= 4685". Later in the
same sheet, I tried to add the value of this cell to another in a formula.
It didn't work. Maybe someone can help with this more specific question.
Thanks in advance.

"Dave R." wrote:

Go ahead -- merely referencing a cell in a formula won't affect the contents
of the referenced cell itself. If the referenced cell references the cell
you'll be referencing it in, you'll get a notice about a circular reference.


"acpharmd" wrote in message
...
I need to link the text in a cell to a value, then use the original cell
in a
formula. Can anyone help?




--

Dave Peterson