Hi Mike

tools / options / view - untick formulas

or

the cell was preformatted as text,
use edit / replace -
look for: =
replace with: =

this tends to fix it

Cheers
JulieD


"Mike" wrote in message
...
In an excel sheet, I am typing in a new formula: "=Master!C271". However,
instead of showing what is in that cell, it shows the formula. Does anyone
know how to fix this?
Thanks!