Date in Excel merges in number format (3/9/07 instead of March 9,

[Beach Lover]

I have an Excel spreadsheet that has a column formatted as DATE with the
FORMAT being March 9, 2007 and it shows up correctly in the spreadsheet, but
when merged the date shows up as 3/9/07. How can I correct this so it merges
as March 9, 2007?

 

[Doug Robbins - Word MVP]

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Beach Lover]

Thanks. I actually found a way to resolve the problem while in Excel.
Create a new column and use the formula: =TEXT(B2, "mmmm dd, yyyy")