Hello--

I had a column with dates and another with text labels.

I'd like to combine these and tried using this formula:

=D6&" "&I6

D6 = 7/4/2009
I6 = HOLIDAY

Is there any way to do this to get the actual date and not the numberical
value returned?

Thanks in advance for your help.