Word03 mail merge with excel formating problem

[Andrew]

mail merge works great but all the numbers from excel
lose their formating. They go from $1,000,000 to 1000000

Any help would be greatly appreciated. I never had this
problem with my older version of Word or Excel?

 

[Doug Robbins - Word MVP]

Hi Andrew,

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

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


--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

 

[Andrew Small]

Where on Word do you go to "format fields with Switches"?

 

[Doug Robbins - Word MVP]

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

Press Alt+F9 to toggle on the display of field codes and add the \#
"$,0.00;($0.00)" switch inside the closing field delimiter }


--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

 

[Graham Mayor]

I have rewritten the preamble to the page Doug recommended. See if you have
any more luck with it.

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

My web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>><