Merging dates to word from Excel

[PaulW]

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

 

[Niek Otten]

In Wxcel, use

=TEXT(A1,"dd mmmm yyyy")

instead of the date field (A1 in this case)

 

[David Biddulph]

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/word/HA011164951033.aspx
http://sbarnhill.mvps.org/WordFAQs/CustomizingWord2002.htm

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