Hi Guys,
A nice easy one for you.
I am trying to combine 2 dates into the 1 cell separated by the word "TO:"
So I have: =B2&" TO: "&C2
Which results in: 40211 TO: 40240
What I need is: 02/02/10 TO: 03/03/10
Could someone please help me with the formatting to have the dates appear in the correct format?
Thanks in advance
Bookmarks