I have a workbook with three sheets. In the first sheet I have a column (A1
thru A68) of stock symbols (ie - AAPL, AGR, APCS, etc) manually entered and
formatted as text. On a second sheet I have entered the formulae
='first sheet'!A1 in cell A1 and ='first sheet'!A2 in cell
C1 and so on. Several of the cells on the second sheet display the proper
info such as "AAPL" but many of the cells only display the entered formula
"='first sheet'!Ax". The formatting for all the cells in the second sheet is
the same (general). I have tried changing this formatting, but nothing seems
to work.

I have found that I can sometimes edit the formula and by deleting and
re-entering the "Ax" portion of the formula, it will sometimes bring up the
proper display. But this does not always work.