Adding cells together where one is a date

[Janet Prince]

How do you stop the date from appearing as a number when you are adding cells together?

[JoePublic]

Welcome to the forum.

Do you mean concatenating, rather than adding? If so, use the TEXT function:
=A1&TEXT(B1,"dd/mm/yyyy")
for example.

[Janet Prince]

Welcome to the forum.

Do you mean concatenating, rather than adding? If so, use the TEXT function:
=A1&TEXT(B1,"dd/mm/yyyy")
for example.

Yes I do mean concatenating and this works so thank you.