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