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

Hi Mark

use
=TEXT(A1,"mm/dd/yyyy") & " to " & text(A2,"mm/dd/yyyy")

Cheers
JulieD

"Mark in Miami" <Mark in wrote in message
...
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