Percentage

[Chi]

Hi,

I have 41% in my data source (Excel) and it displays 0.41354836739 in Word
(my letter).

I got a message Syntax Error when I try to correct the % formatting.
{={MERGEFIELD PROD}*100\#"0%"}


Please help me to fix it.

Thanks
Chi

 

[Rich/rerat]

Chi,
Try the following:
{MERGEFIELD PROD}*100 \# "0%"}

Watch the spacing, there should be a space between "*100" & the "\", and "#"
& "0%"


--
Add MS to your News Reader: news://msnews.microsoft.com
Rich/rerat
(RRR News) <message rule>
<<Previous Text Snipped to Save Bandwidth When Appropriate>>


Hi,

I have 41% in my data source (Excel) and it displays 0.41354836739 in Word
(my letter).

I got a message Syntax Error when I try to correct the % formatting.
{={MERGEFIELD PROD}*100\#"0%"}


Please help me to fix it.

Thanks
Chi

 

[Chi]

Hi Rich,

I tried it and I got 0% as result. Please help
Thank you very much!
Chi

 

[Doug Robbins - Word MVP]

The field construction that you require is

{ = { MERGEFIELD PROD } * 100 \# "0%" }

Each pair of field delimiters { } must be inserted by using Ctrl+F9

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

 

[Chi]

Hi Doug,

Thank you very much! it works perfectly!
Chi