Adding cells together where one is a date

**Janet Prince** · 2013-12-20, 11:16 AM

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

**JoePublic** · 2013-12-20, 11:34 AM

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** · 2013-12-20, 11:49 AM

Originally Posted by 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.

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

Thread: Adding cells together where one is a date