View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default 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