String Dates

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
 
P

Peo Sjoblom

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)
 
C

Carla

As I stated in original request, you all are awesome!
Keep up the great work!
Carla
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - exporting serial letters to single documents 0
Date Format 10
Date Format 2
How to enter a date in DD-MM-YYYY format 2
date and time difference 19
Criteria For SU<IF 5
Publisher is filling blank lines with data 2
date computing and sum issues 6

Top