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