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
|