percentages change when mail merge from excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cynthia - 20 Mar 2006 19:47 GMT

after mail merge, I can't get the percentage to format correctly. I have
checked confirm conversion at home, tried MS excel worksheets via DDE, and
changed to text, edited the fields. Nothing seems to be working. The
closest I've gotten was that it showed the percent but had the decimal point
at the beginning on of the number, i.e. ".44%" instead of "44%".

Reply to this Message

Doug Robbins - Word MVP - 20 Mar 2006 22:00 GMT

In the mail merge main document, press Alt+f9 to display the field codes.
Then modify it to the following

{ = { MERGEFIELD [fieldname] } * 100 \# "0%" }

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

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

Signature

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

> after mail merge, I can't get the percentage to format correctly. I have
> checked confirm conversion at home, tried MS excel worksheets via DDE, and
> changed to text, edited the fields. Nothing seems to be working. The
> closest I've gotten was that it showed the percent but had the decimal
> point
> at the beginning on of the number, i.e. ".44%" instead of "44%".

Reply to this Message

Cynthia - 20 Mar 2006 22:15 GMT

I've tried this and I get a syntax error, I've even just tried copying the
whole statement and just changing the fieldname and it doesn't work.

> In the mail merge main document, press Alt+f9 to display the field codes.
> Then modify it to the following
[quoted text clipped - 12 lines]
> > point
> > at the beginning on of the number, i.e. ".44%" instead of "44%".

Reply to this Message

Doug Robbins - Word MVP - 21 Mar 2006 06:10 GMT

Copying it definitely will not work. You must use Ctrl+F9 to insert each
pair of field delimiters { }

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

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

Signature

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

> I've tried this and I get a syntax error, I've even just tried copying the
> whole statement and just changing the fieldname and it doesn't work.
[quoted text clipped - 17 lines]
>> > point
>> > at the beginning on of the number, i.e. ".44%" instead of "44%".

Reply to this Message

Cynthia - 21 Mar 2006 15:49 GMT

Thank you!! this time it worked, maybe I just needed to look at something
else for awhile.

> Copying it definitely will not work. You must use Ctrl+F9 to insert each
> pair of field delimiters { }
[quoted text clipped - 25 lines]
> >> > point
> >> > at the beginning on of the number, i.e. ".44%" instead of "44%".

Reply to this Message