G
Guest
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
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