Hi!

Those cells are formatted as text.

Select the cells in question
Goto FormatCellsNumberGENERALOK

With those cells still selected
Goto EditReplace
Find what: =
Replace with: =
Replace All

Biff

"nia" wrote in message
...

I apologize iof this is answered somewhere already, but I can't find
it.

I'm using the info in a worksheet to populate the cells in another. I
use the appropriate formula to reference the worksheet ie.
=Sheet1!A46. It works in some cells but in others it simply displays
the formula itself. The cells are formatted the same whether it be
text, number, currency, etc.

Any ideas would be greatly appreciated.


--
nia
------------------------------------------------------------------------
nia's Profile:
http://www.excelforum.com/member.php...o&userid=29334
View this thread: http://www.excelforum.com/showthread...hreadid=490482