View Single Post
  #1   Report Post  
Jean Simon
 
Posts: n/a
Default seeing the formula (not the cell)

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