Excel Concatenate Long Date Format
How do I get the concatenate formula in Excel to give me the output in Long Date Format. I tried to format the cell, but it is still just returning a string of numbers instead of the long date from the cell I pointed it to.
1 answer
-
Marcin Policht 94,375 Reputation points • MVP • Volunteer Moderator
When you concatenate a date in Excel, Excel converts the date to its underlying serial number. Cell formatting will not fix it because the formula output is now text. Use the TEXT function inside the concatenation to force the date format.
Example:
=CONCAT("Report Date: ",TEXT(A1,"dddd, mmmm d, yyyy"))If A1 contains 6/28/2026, the result should be:
Report Date: Sunday, June 28, 2026
You can also try:
=A1 & " - " & TEXT(B1,"mmmm d, yyyy")The TEXT format string controls how the date appears.
If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.
hth
Marcin