Cell displays formula and not result
 

This is a major annoyance....
Some cells do not display the result of a formula, they will rather display
the formula.
For example if I want to concatenate three text cells with the formula
=A1&B1&C1 the cell displays the formula and not the expected result.
This will happen with different formulas referencing other cells.
Excel 2002 SP3
I have not yet found the correct combination of curse words to fix it, any
help please...

Ettienne

It sounds like the cells in which you are entering the formula is formatted
as text. It should be formatted as general or else excel thinks the data you
are entering is text, even though it starts with a =

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Ettienne" wrote in message
...
This is a major annoyance....
Some cells do not display the result of a formula, they will rather
display
the formula.
For example if I want to concatenate three text cells with the formula
=A1&B1&C1 the cell displays the formula and not the expected result.
This will happen with different formulas referencing other cells.
Excel 2002 SP3
I have not yet found the correct combination of curse words to fix it, any
help please...

Ettienne wrote:
This is a major annoyance....
Some cells do not display the result of a formula, they will rather display
the formula.
For example if I want to concatenate three text cells with the formula
=A1&B1&C1 the cell displays the formula and not the expected result.
This will happen with different formulas referencing other cells.
Excel 2002 SP3
I have not yet found the correct combination of curse words to fix it, any
help please...

Tools-Options and on the View tab uncheck the Formula box in the Window
Options section

--
Registered Linux User no 240308
Just waiting for Broadband to complete the conversion!(3 weeks and
counting!)
gordonATgbpcomputingDOTcoDOTuk
to email me remove the obvious!

Cells are formatted as Text.

Format to General then F2 and <ENTER to re-do.

If you have a great whack of these, select them then EditReplace

What: =
With: =

Replace All.


Gord Dibben Excel MVP



On Thu, 3 Feb 2005 14:11:04 -0800, "Ettienne"
wrote:

This is a major annoyance....
Some cells do not display the result of a formula, they will rather display
the formula.
For example if I want to concatenate three text cells with the formula
=A1&B1&C1 the cell displays the formula and not the expected result.
This will happen with different formulas referencing other cells.
Excel 2002 SP3
I have not yet found the correct combination of curse words to fix it, any
help please...

Many, many thanks for this bit of information. I was sure my version of Excel was possessed and deliberately being difficult, it wouldn't respond at all despite banging my head on the monitor, but this has sorted the problem.

Make sure that the cells are not formatted as Text. Cells formatted as Text
treat entered formulas as simple character strings.
--
Gary's Student


"littlepetel" wrote:


Many, many thanks for this bit of information. I was sure my version of
Excel was possessed and deliberately being difficult, it wouldn't
respond at all despite banging my head on the monitor, but this has
sorted the problem.

Ettienne Wrote:
This is a major annoyance....
Some cells do not display the result of a formula, they will rather
display
the formula.
For example if I want to concatenate three text cells with the formula
=A1&B1&C1 the cell displays the formula and not the expected result.
This will happen with different formulas referencing other cells.
Excel 2002 SP3
I have not yet found the correct combination of curse words to fix it,
any
help please...


--
littlepetel