View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default 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