Literally hundreds of people have asked the same question here. You will
find the answer in the article "Formatting Word fields with switches" on
fellow MVP Graham Mayor's website at
http://www.gmayor.com/formatting_word_fields.htm

Signature
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.
Hope this helps,
Doug Robbins - Word MVP
>I have numerous fields I am merging into a letter and the one with problems
> is a balance field. I've tried using Excel and Access as the data source
[quoted text clipped - 3 lines]
> to 6
> or 8 digits. Help