Problems with field switches

Problems with field switches - percentages

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mel Davidson - 29 Apr 2004 21:06 GMT

Please help!! This is the first time I've used Word 2003 to merge from Excel, and I am frustrated that the Excel cells don't keep their format. After many hours, I've figured out most of the numeric field switches, but I'm stuck on one

I have an Excel column that shows percentages carried out 4 decimal points such as 0.1234% and 4.3210%. I've tried playing around with the following but it doesn't work....{ MERGEFIELD "Partner Percentage" \# "0.0000x"} Instead of 0.1234% it shows up as 0.00123% which is wrong

Any ideas? Thank you!

Reply to this Message

Doug Robbins - Word MVP - 30 Apr 2004 03:47 GMT

Use

{ = 100 * { MERGEFIELD "Partner Percentage" \# "0.0000"} }

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

> Please help!! This is the first time I've used Word 2003 to merge from Excel, and I am frustrated that the Excel cells don't keep their format.

After many hours, I've figured out most of the numeric field switches, but
I'm stuck on one.

> I have an Excel column that shows percentages carried out 4 decimal points such as 0.1234% and 4.3210%. I've tried playing around with the following

but it doesn't work....{ MERGEFIELD "Partner Percentage" \# "0.0000x"}
Instead of 0.1234% it shows up as 0.00123% which is wrong.

> Any ideas? Thank you!!

Reply to this Message