Janet Prince
New member
- Joined
- Dec 20, 2013
- Messages
- 2
- Reaction score
- 0
- Points
- 0
How do you stop the date from appearing as a number when you are adding cells together?
Adding cells together where one is a date
- Thread starter Janet Prince
- Start date
Janet Prince
New member
- Joined
- Dec 20, 2013
- Messages
- 2
- Reaction score
- 0
- Points
- 0
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.