worksheet reference returns address instead of value
 

I'm "pointing to" a cell in another worksheet. I should be able to hit "="
then click on the worksheet and cell I want, then hit enter. The value in
the referenced cell should now show in the new worksheet. Instead, I'm
seeing the address of the referenced cell.

Has anyone had this problem? Is there possibly something in the formatiing
of the two worksheets that's causing a problem?

worksheet reference returns address instead of value
 

The cell was probably formatted as text before you entered the formula.
Format as general *and re-enter the formula* (F2, ENTER)

--
Kind regards,

Niek Otten

"pobruce" wrote in message
...
I'm "pointing to" a cell in another worksheet. I should be able to hit
"="
then click on the worksheet and cell I want, then hit enter. The value in
the referenced cell should now show in the new worksheet. Instead, I'm
seeing the address of the referenced cell.

Has anyone had this problem? Is there possibly something in the
formatiing
of the two worksheets that's causing a problem?

worksheet reference returns address instead of value
 

I'm guessing that the cell you are entering the "=" sign into is formatted as
text.

Re-format to General and try again.

OR you have "View Formulas" enabled.

Hit CTRL + `(backquote above Tab key) to toggle on/off.


Gord Dibben MS Excel MVP

On Fri, 20 Jan 2006 13:09:01 -0800, "pobruce"
wrote:

I'm "pointing to" a cell in another worksheet. I should be able to hit "="
then click on the worksheet and cell I want, then hit enter. The value in
the referenced cell should now show in the new worksheet. Instead, I'm
seeing the address of the referenced cell.

Has anyone had this problem? Is there possibly something in the formatiing
of the two worksheets that's causing a problem?