Since you say that only *some* cells exhibit this problem, I would guess
that the "bad" cells were probably formatted as text,*before* you entered
the formulas.

If that's the case, you must change the formatting *and* re-register the
formula in order to obtain a valid XL formula.

Try this:
Select a "bad" cell,
Then
<Ctrl <Shift < ~
Then
<F2
Then
<Enter

What you did here, was
Keyboard shortcut to "General" format
Enter "Edit" mode
Re-register formula.

If you have a great many of these problem cells (formulas), you can select
them all,
Change the format en masse,
<Ctrl <Shift < ~

Re-register en masse using,
<Edit <Replace

Find what
=
Replace with
=
<Replace All

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Jay Mac" wrote in message
...
Some cells on the worksheet will show the information in the referenced
cell.
Others only show the statement. For example, if I enter ='log'!K5, that's
exactly what appears in that cell, not the contents of the referenced cell.

John