Troubleshoot autoformat of dates with mail merge

[rose333]

I am using Excel 2003 with Windows XP. In my excel doc I have a specific calculation for my date fields, therefore they must be in a date format. It shows as December 1, 2005. But when I merge it with word it shows as 12/1/05. I would like it to show as December 1, 2005. Is there a way that I can change this without messing up my formulas in excel.

Any help would be great!
Thanks

 

[Norie]

What you need to do is in Word use switches to format the MERGEFIELD.

Check out Help for more information.

 

[rose333]

Thanks for your quick response. I right clicked on my merge field but the options there did not work. What do you mean by switches?

 

[Norie]

Here's an example.

{ MERGFIELD MyDate \@ "dddd, MMMM d, yyyy" }

The \@ is to indicate it's a date and the "dddd, MMMM d, yyyy" is how you want it formatted.

For a full list of switches just check out help for MERGEFIELD.

 

[rose333]

Thanks a bunch. Have a happy New Year!