concatenate date cell format

[WLHagen]

Hey all!

I'm using Excel 2007. I'm trying to concatenate several cells into a new string, and I'm having trouble with how a date cell shows in the new (concatenated) cell. If the date in the originating cell is 06/27/2013, the concatenated cell shows it as 41452.

Thanks in advance for your assistance!!!!

 

[wigi]

For instance:

="Today is " & TEXT(Today(),"mmddyyyy")

 

[Oaktree]

Use the TEXT function.

If A1 has your date, try ="Today's date is "&TEXT(A1,"MM/DD/YYYY")

 

[WLHagen]

Y'all are the BOMB-Diggety!!!!!

It worked PERFECTLY!

Sorry for the delay in reply - I posted this just before going to meetings, then had offline "stuff" to do... "life happened"