Concatenation changes date format to a number Excel 2010 1

[EcoWill]

Hi all - I am concatenating three cells in Excel, (two text, and last one a date) and the concatenation works but is converting the date value into a number. How do we keep it as a date format? Thanks

 

[SkipVought]

hi,

NOTHING is being converted!

Dates are NUMBERS!

What you see displayed is simply a FORMAT. A date can be formatted in nearly an infinite number of ways.

Assuming that your 3 cells are A1, B1, C1 and C1 is your Date, then ONE format might be...
[tt]
=A1&B1&TEXT(C1,"dddd yyyy mmm dd")
[/tt]


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[EcoWill]

That works. Thanks.