Excel displays formulae, not results

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have inherited a spread sheet that has a number of formulae in it. However when I type in a new formula, it displays it as the formula, not as the result. This is not applicable to all cells, just some of them. I am now reduced to copying a formula that displays the result, then editing it to give the formula that I actually want. Obviously there is some setting in the individual cells that governs how it displays as well as the general setting.
 
Hi Roger,

This happens when a cell is formatted as text the moment
--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
you enter the formula. Change the format to general and re-enter the
formula (F2, ENTER)

Roger Gaunt said:
I have inherited a spread sheet that has a number of formulae in it.
Click to expand...
However when I type in a new formula, it displays it as the formula, not as
the result. This is not applicable to all cells, just some of them. I am now
reduced to copying a formula that displays the result, then editing it to
give the formula that I actually want. Obviously there is some setting in
the individual cells that governs how it displays as well as the general
setting.
 
I meant to say:

This happens when a cell is formatted as text the moment you enter a
formula. Format as General and re-enter the formula (F2, ENTER).

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
If you have many of these, select all and format as General then go to
Edit>Replace

What: =
With: =

Replace all.

Gord Dibben XL2002
 
Back
Top