If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Field formatting during mail merge
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! |
#2
|
|||
|
|||
Field formatting during mail merge
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. -- 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 "FrankZ" wrote in message ... 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! |
Thread Tools | |
Display Modes | |
|
|