I have 2 cells (A1 and A2, for this purpose) formatted for date holding 2
dates really as serial numbers.

A1 = 1/1/2005
A2 = 12/31/2005

I need to place in cell A3 the following text "1/1/2005 to 12/31/2005".

Everytime I try, it pops in the srial numbers for the dates and looks like
"38800 to 39800".

How can I get the 2 dates to concatenate as strings??
URGENT and desperate!
Mark in Miami