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...