EXCEL CELL MERGE

  • Thread starter Thread starter Patricia
  • Start date Start date
P

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!!
 
Patricia said:
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!!
Click to expand...


You need the TEXT() worksheet function.

Something like this...

=H3&" "&TEXT(G3,"dddd, mmmm dd, yyyy")&" "&H4
 
=A1&" "&B1&" "&TEXT(C1," mmm dd yyyy")

Assumes C1 has a valid date.


Gord Dibben MS Excel MVP
 
Patricia said:
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!!
Click to expand...

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