External Link Shows Formula Not Info
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 |
External Link Shows Formula Not Info
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 |
External Link Shows Formula Not Info
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 |
External Link Shows Formula Not Info
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 |
All times are GMT +1. The time now is 03:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com