Merging dates to word from Excel
 

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

Merging dates to word from Excel
 

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

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