String Dates

  • Thread starter Thread starter Carla
  • Start date Start date
C

Carla

In Excel, I have date fields that appear as mm/dd/yy and
would like to string them together. When I do this, the
dates turn into their corresponding number, they don't
appear as mm/dd/yy. Can anyone help me with the way to
make this happen?

Thank you all that help! You are doing a great service
to all that visit here!

Carla
 
Use the text function

="blabla"&text(date,"mm/dd/yy")&"blabla"&next text formula

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Back
Top