Percentage Mail Merge Formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Michele - 17 Feb 2004 19:30 GMT

I'm merging from a spreadsheet which has columns formatted
for percentages (i.e 27.15%). I've tried adding the
following switches, but have not been able to get the
formatting to carry over into the mass letters I'm
creating:

{ = 100 * {MERGEFIELD "F" net_util } \# "0.00%" (I get a
snytax error)

{ = "MERGEFIELD "F"} * 100 \# "0.00%"} (I get 0.10%)

Is there something I'm missing? This is driving me so
insane!

TIA

Michele

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 18 Feb 2004 02:40 GMT

Hi Michele,

Try

{ = 100 * {MERGEFIELD "F" } \# "0.00%" }

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'm merging from a spreadsheet which has columns formatted
> for percentages (i.e 27.15%). I've tried adding the
[quoted text clipped - 13 lines]
>
> Michele

Reply to this Message