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
Cell showing formula instead of date 6
How do I get rid of an external link which I can't find? 1
Values not showing in either cell or formula bar 2
How do I attach a number to a cell with text to use in a formula? 1
how do i show the calculated value in a cell rather than formula 3
How do I keep a hyperlink valid if the link to cell is moved? 1
Linking formula to external spreadsheet 1

Top