merging a date

[Guest]

I have a date in the format yyyymmdd in an Excel spreadsheet I am merging into a Word document. I need the date in something like MMMMM dd, yyyy or mm-dd-yyyy. I have tried the format date options, but none that I have found recognize yyyymmdd as a date. What can I try?

 

[Guest]

Hi, Angela N. In your Word document, press Alt+F9 to toggle field code display on, then add a picture switch to your date mergefield. For example, { MERGEFIELD Date \@ "MMMM dd, yyyy" } or { MERGEFIELD Date \@ "mm-dd-yyyy" }. Press Alt+F9 again to toggle field code display off.

 

[Graham Mayor]

You will probably need to update the field to reflect the new information
(F9)
See also http://www.gmayor.com/formatting_word_fields.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>