It sounds as if the cell was formatted as text before you entered the
formula. Format the cell as General, then either re-enter the formula or F2
to edit and enter.
Another possibility is that you're displaying formulae, rather than their
results. Control + ` (Control and grave accent) to toggle.
--
David Biddulph

"Felix" wrote in message
...
When I enter the formulae =CONCATENATE(A2,B2) or =A2&B2 rather than
joining
the two texts, the formula as such is visible. This happens even when I
enter
the formula via "Insert Function" where the result of the combined text is
visible!
--
Felix