seeing the formula (not the cell)

J

Jean Simon

Hi All,

Suddendly, I have this strange behaviour.

I have a cell say C3 which contains 2b as a text.

Then on cell I4, I want to se the content of cell C3. on cell I4, I used to
type
=C3, then on I4, I would see 2b. What is strange now, is that on I4, I see
=C3 (the "formula" and not the result). What is more surprizing, is that
on this excell file, I have 2 sheets. On the first sheet, referencing works
fine.
On the second sheet, I can see only the formula.
What do I do to not see the formula, but the resut ? I don't remeber touching
any option.

Regards
Jean Simon
 
N

Niek Otten

Your cell was formatted as text before you entered the formula. Format as
General and re-enter the formula (F2, Enter)

--
Kind regards,

Niek Otten

Microsoft MVP - Excel
 
J

Jean Simon

HI,

Thank you very much. I did not think to check the format.

Regards
Jean Simon.
 
Top