"polk383" wrote in
message ...

Hey again... Hopefully this is not another stupid issue like last time.
Working with more than one worksheet and I am trying to pull two dates
into one cell. For example: Worksheet 1 - Cell A1 - has a date of
"06/03/05" and on worksheet 2 - Cell A1 - has a date of "06/04/05".
What I am looking for on Worksheet 3 Cell A1 to have "06/03/05" -
"06/04/05". I have formated everything to be mm/dd/yy and when I
attempt this i get a something that looks like this "38878-38886" I
was using the formula:
=Worksheet1!A1 & "-" & Worksheet2!A1

Because you're wanting to produce a text string to concatenate, I think you
need something of the form
=TEXT(Worksheet1!A1,"mm/dd/yy")&"-"&TEXT(Worksheet2!A1,"mm/dd/yy")
--
David Biddulph