#1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Chi Chi is offline
external usenet poster
 
Posts: 37
Default Percentage

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
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Rich/rerat Rich/rerat is offline
external usenet poster
 
Posts: 93
Default Percentage

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


"Chi" wrote in message
...
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


  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Chi Chi is offline
external usenet poster
 
Posts: 37
Default Percentage

Hi Rich,

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

"Rich/rerat" wrote:

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


"Chi" wrote in message
...
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



  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Percentage

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" wrote in message
...
Hi Rich,

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

"Rich/rerat" wrote:

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


"Chi" wrote in message
...
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




  #5   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Chi Chi is offline
external usenet poster
 
Posts: 37
Default Percentage

Hi Doug,

Thank you very much! it works perfectly!
Chi

"Doug Robbins - Word MVP" wrote:

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" wrote in message
...
Hi Rich,

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

"Rich/rerat" wrote:

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


"Chi" wrote in message
...
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





Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
percentage Briggs Tables 3 April 27th 09 10:16 PM
percentage mail merge Martha Mailmerge 1 November 17th 07 07:32 PM
Percentage in form field Purplejopeg Tables 2 October 18th 07 02:22 PM
Mail Merge Percentage Mishy Mailmerge 3 December 15th 06 05:19 PM
decimal to percentage Chris G New Users 0 April 12th 05 11:41 PM


All times are GMT +1. The time now is 07:20 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"