[stan]

i completed a mail merge. my word doc is displaying decimals up to 6 places
although excel is limited to 2. i tried using the switch mentioned on
http://www.gmayor.com/formatting_word_fields.htm but still didn't get it to
work.

below is my switch attempt and the results.
{ MERGEFIELD "Mailmerge_CPM_Credit_due"\# "$,0.00;($0.00)" }
0.47999999999999998

Any help would be greatly appreciated.

[Graham Mayor]

Did you update the field after adding the switch? It works for me as you
have written it.
Note that Word can get confused if you use overlong field names - like
yours!

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org

stan wrote:
i completed a mail merge. my word doc is displaying decimals up to 6
places although excel is limited to 2. i tried using the switch
mentioned on http://www.gmayor.com/formatting_word_fields.htm but
still didn't get it to work.

below is my switch attempt and the results.
{ MERGEFIELD "Mailmerge_CPM_Credit_due"\# "$,0.00;($0.00)" }
0.47999999999999998

Any help would be greatly appreciated.