Field formatting during mail merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

FrankZ - 06 May 2004 16:11 GMT

I am using an Excel spreadsheet as the datasource for
batting avg, etc. How can I control the format of the
merged fields to show as 9.999%? Currently a 1.000
average shows as 1 and a 0.666 average shows as
0.666666666. The source fields in the spreadsheet are
already formatted to 3 decimal places. Thanks!

Reply to this Message

Doug Robbins - Word MVP - 07 May 2004 00:36 GMT

Add a \# "0.000%" formatting switch inside the closing } that is displayed
when you toggle on the field codes using Alt+F9

You may need to use a construction such as { = { MERGEFIELD "Average" } *
100 \# "0.000%" } or some other multiplier to get the correct percentage.

Signature

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

> I am using an Excel spreadsheet as the datasource for
> batting avg, etc. How can I control the format of the
> merged fields to show as 9.999%? Currently a 1.000
> average shows as 1 and a 0.666 average shows as
> 0.666666666. The source fields in the spreadsheet are
> already formatted to 3 decimal places. Thanks!

Reply to this Message