New formula: = does not disappear

M

Mike

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!
 
J

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
 
M

Mike

Thanks Julie. This worked like a charm!

JulieD said:
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
Click to expand...
 
Top