View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Merging dates to word from Excel

Either use field formatting within Word:
http://word.mvps.org/FAQs/MailMerge/
http://www.mvps.org/dmcritchie/excel/mailmerg.htm
http://office.microsoft.com/en-gb/wo...164951033.aspx
http://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm

or use =TEXT(A1,"dd mmmmm yyyy")
--
David Biddulph

"PaulW" wrote in message
...
Hi

I am merging some dates from an Excel s/s into Word but I want it to
arrive
in the

full length text string format (dd mmmmm yyyy) and not numerical

is it possible

thanks PW