Concatenating Text + Date

  • Thread starter Thread starter Daniel Bonallack
  • Start date Start date
D

Daniel Bonallack

I have the text "The date is " in Cell A1
In cell B1 I have 03/31/04 (formated as a date)

In cell C1 I have "=A1&B1", which gives me
"The date is 38077.4312601852"

How can I get the result:
"The date is 03/31/04"

Thank you in advance
Daniel
 
=A1&TEXT(B1,"mm/dd/yy")

but 38077.4312601852 tells me you have a time with that
date, so maybe:

=A1&TEXT(B1,"mm/dd/yy hh:mm AM/PM")

HTH
Jason
Atlanta, GA
 
Back
Top