Try this:

Select the cell that is showing the formula
Goto the menu FormatCellsNumber tabGENERALOK
Hit function key F2
Hit ENTER

--
Biff
Microsoft Excel MVP


"Victor Delta" wrote in message
...
This is most odd. In one of my spreadsheets (using Excel 2002/XP) I have
links to copy numbers and text from another sheet. The number links work
fine.

However, whilst some of the text links work ok others do not and simply
appear as their formulae, for example:

='[Performance Report.xls]Performance'!$A$24

What is odd is that an absolutely identical link to the above does work ok
whereas two cells below it appears as above.

I have checked all the obvious things (e.g. that the 'show formulae'
option is not set) and copied the format of the 'working' cells to the
'unworking' cells - all to no avail.

Has anyone any ideas what might be causing this and how to fix it please?

Thanks,

V