Problems with field switches - percentages

[Mel Davidson]

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!

 

[Doug Robbins - Word MVP]

Use

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

--
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.