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

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

"Jean Simon" wrote in message
...
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

Or perhaps you're in formual view mode - Ctrl+` to exit (or enter).

"Niek Otten" wrote:

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

"Jean Simon" wrote in message
...
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

HI,

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

Regards
Jean Simon.


"Niek Otten" wrote:

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

"Jean Simon" wrote in message
...
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