[NancyL]

When using Excel as a data source, the date and time formats change when
placed in a Word doc as a mail merge field. How do I keep the format that I
have in Excel?

[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, originally posted via msnews.microsoft.com
"NancyL" wrote in message
...
When using Excel as a data source, the date and time formats change when
placed in a Word doc as a mail merge field. How do I keep the format that
I
have in Excel?

[NancyL]

Thank you

"Doug Robbins - Word MVP" wrote:

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, originally posted via msnews.microsoft.com
"NancyL" wrote in message
...
When using Excel as a data source, the date and time formats change when
placed in a Word doc as a mail merge field. How do I keep the format that
I
have in Excel?