It sounds like the cell is pre-formatted as Text. Change the format to
General, then re-enter your formula (without the apostrophe at the
beginning).

A shorter way to set up the formula is:

=D10 & D11

Hope this helps.

Pete

On Feb 19, 4:52*pm, JennieSarah
wrote:
Hi;

Im hoping that im making a really silly error here myself but I really
cannot see whats wrong and getting frustrated!
Im using the Concatenate function within my worksheet but after setting up
the function and pressing the enter key, nothing happens at all. No result is
shown for the formula, just the formula itself is displayed within the cell:
'=concatenate(d10,d11)'
I have already checked to make sure that the worksheet is not set up to show
the formulas and have tested out anything that I think could be affecting it
but to no avail.
Are there certain types of cell contents that cannot be used with this
function or is there something that I am missing perhaps?

Any help is greatly, greatly appreciated!

Many thanks,
Jen