EXCEL CELL MERGE

[Patricia]

I am trying to merge multiple text cells and a date cell ...
So far, it won't let the data in the date cell show as a date, only as number.

Help!!

 

[Glenn]

I am trying to merge multiple text cells and a date cell ...
So far, it won't let the data in the date cell show as a date, only as number.

Help!!

You need the TEXT() worksheet function.

Something like this...

=H3&" "&TEXT(G3,"dddd, mmmm dd, yyyy")&" "&H4

 

[Gord Dibben]

=A1&" "&B1&" "&TEXT(C1," mmm dd yyyy")

Assumes C1 has a valid date.


Gord Dibben MS Excel MVP

 

[Patricia]

I am trying to merge multiple text cells and a date cell ...
So far, it won't let the data in the date cell show as a date, only as number.

Help!!

Thank you for the answers! You made me look like a whiz kid to my boss!!