Concatenate Dates
 

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

Concatenate Dates
 

Try this with date in A1

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

If this post helps click Yes
---------------
Jacob Skaria


"EllenM" wrote:

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

Concatenate Dates
 

Thanks, Jacob. Code works beautifully!!