How do I get rid of the link cell showing the linking formula

A

Andrew M

Sometimes when I link a cell to another in a different spreadsheet it will
only show the formula not the result.
E.g.

The cell shows "='[PNP stockasat220409(1) Working V2 New SKU
identified.xlsx]Stock List - Supplier Informati'!A4"
This is seen, I owuld have expected the value in the cell reference to show.
This is only happening sometimes.
Any ideas on how to correct?
Andrew
 
S

Sheeloo

This happens when the cell containing the formula is formatted as TEXT.
Change the formula to GENERAL.

Also make sure that the first character in the cell is = and you have not
inadvertently entered ' before =
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I get rid of duplicate rows? 5
How do I attach a number to a cell with text to use in a formula? 1
Cell showing formula instead of date 6
Values not showing in either cell or formula bar 2
How DO I Increase The Excel Cell Comment Data Capacity? 1
How do I get rid of an external link which I can't find? 1
How do I make a cell = the sheet name? 3
how do i show the calculated value in a cell rather than formula 3

Top