New formula: = does not disappear

[Guest]

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!

 

[JulieD]

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

 

[Guest]

Thanks Julie. This worked like a charm!

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

 

[JulieD]

you're welcome and thanks for the feedback

Thanks Julie. This worked like a charm!