you're welcome and thanks for the feedback

"Mike" wrote in message
...
Thanks Julie. This worked like a charm!

"JulieD" wrote:

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!