Concatenate Dates

[EllenM]

Hello,
I need help to concatenate a date field. For example, I'd like one of them
to say "Posted 1/12/2007". Instead I'm getting "Posted 39094".

Thanks in advance for your help.

Ellen

 

[Jacob Skaria]

Try this with date in A1

="Posted " & TEXT(A1,"mm/dd/yyyy")

If this post helps click Yes

 

[EllenM]

Thanks, Jacob. Code works beautifully!!