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

In Wxcel, use

=TEXT(A1,"dd mmmm yyyy")

instead of the date field (A1 in this case)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"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

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