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

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

Thank you so much! this has been bugging me for months. Thanks so much!
What a great forum. I'm sure I'll be back. :)


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

this has been bugging me for months.

Don't wait so long the next time you have a question or problem!

Thanks for the feedback!

Biff

"nia" wrote in message
...

Thank you so much! this has been bugging me for months. Thanks so much!
What a great forum. I'm sure I'll be back. :)


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