New formula: = does not disappear
 

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!

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!

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!

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!