I want my concatenate to display the date and not the number behind the text!

  • Thread starter Thread starter scottwilson
  • Start date Start date
S

scottwilson

Hope someone can help. I have calculated a cell, say it is G4. I want t
write a CONCATENATE which will display something like:
"Monday the 16th February 2004".
My formula is =CONCATENATE(H4," ","the ",LEFT(G4,2)," ","of",
",TEXT(G4,"mmmm")) and it works perfectly except where I have entere
LEFT(G4,2) it returns the first 2 numbers of the serial number behin
the date eg: 38.

Can someone tell me how to change it so that it returns 16 instead o
the generated number?

Many thanks
Scott
 
Hi Scott
just format G4 with the custom format
TTTT "the" TT"th" MMMM YYYY

note: a small problem arises with using 'th' for example the 1st of
February.
 
Hi Frank, this works perfectly! cheers and thanks for getting back s
soon!

Scott
 
Back
Top