So, I'm trying to combine two cells with dates in them. The format from microsoft suggests this: =(A1&" - "&B1)
However, when you put dates in there it moves from something like 1/2/2010 & 2/1/2010 it gives you something along the lines of 40180 - 40210. How do I get it to keep the format for the dates in the referenced cells?
Bookmarks