Help!

Percentage format in merge from excel

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> MailMerge Fields RSS
Next:  Word Dictionary  
Author Message
Lica
External


Since: Nov 16, 2006
Posts: 4



PostPosted: Thu Nov 16, 2006 9:05 am    Post subject: Percentage format in merge from excel
Archived from groups: microsoft>public>word>mailmerge>fields (more info?)

I have a mail merge with word & excel. In the excell I have numbers with the
percentage format, that it is not poplating into word.
I traied to use the coding # "##%" , but it is not working. Also I cannot
remove the percentage format from the excel.

Thanks
Back to top
macropod
External


Since: Sep 27, 2005
Posts: 994



PostPosted: Fri Nov 17, 2006 4:22 am    Post subject: Re: Percentage format in merge from excel [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Hi Lica,

If Word is showing something like '12.34' without the percentage sign and
you need it to show '12%', try adding the '\# 0%'picture switch to your
mergefield. For example {MERGEFIELD ExcelData \# 0%}

Alternatively, if Word is showing something like '0.1234' with or without
the percentage sign and you need it to show '12%', try selecting your
mergefield, pressing Ctrl-F9 to embed it in another field and code the lot
as: '{={MERGEFIELD ExcelData}*100 \# 0%}', or '{={MERGEFIELD ExcelData}*100
\# 0.00%}' for '12.34%'.

Cheers

--
macropod
[MVP - Microsoft Word]


"Lica" wrote in message

> I have a mail merge with word & excel. In the excell I have numbers with
the
> percentage format, that it is not poplating into word.
> I traied to use the coding # "##%" , but it is not working. Also I cannot
> remove the percentage format from the excel.
>
> Thanks
Back to top
Lica
External


Since: Nov 16, 2006
Posts: 4



PostPosted: Fri Nov 17, 2006 4:22 am    Post subject: Re: Percentage format in merge from excel [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Hi,

thanks, but it didn't work.

The second options id what I need, word is showing 0.123 without the %. I
tried the solution several times, but the result it '!Syntax Error, {'.

There is another possibility?

Thanks!

"macropod" wrote:

> Hi Lica,
>
> If Word is showing something like '12.34' without the percentage sign and
> you need it to show '12%', try adding the '\# 0%'picture switch to your
> mergefield. For example {MERGEFIELD ExcelData \# 0%}
>
> Alternatively, if Word is showing something like '0.1234' with or without
> the percentage sign and you need it to show '12%', try selecting your
> mergefield, pressing Ctrl-F9 to embed it in another field and code the lot
> as: '{={MERGEFIELD ExcelData}*100 \# 0%}', or '{={MERGEFIELD ExcelData}*100
> \# 0.00%}' for '12.34%'.
>
> Cheers
>
> --
> macropod
> [MVP - Microsoft Word]
>
>
> "Lica" wrote in message
>
> > I have a mail merge with word & excel. In the excell I have numbers with
> the
> > percentage format, that it is not poplating into word.
> > I traied to use the coding # "##%" , but it is not working. Also I cannot
> > remove the percentage format from the excel.
> >
> > Thanks
>
>
>
Back to top
Graham Mayor
External


Since: Jul 04, 2006
Posts: 4874



PostPosted: Fri Nov 17, 2006 4:22 am    Post subject: Re: Percentage format in merge from excel [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

You didn't use CTRL+F9 to enter the curly brackets - see
http://www.gmayor.com/formatting_word_fields.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

Lica wrote:
> Hi,
>
> thanks, but it didn't work.
>
> The second options id what I need, word is showing 0.123 without the
> %. I tried the solution several times, but the result it '!Syntax
> Error, {'.
>
> There is another possibility?
>
> Thanks!
>
> "macropod" wrote:
>
>> Hi Lica,
>>
>> If Word is showing something like '12.34' without the percentage
>> sign and you need it to show '12%', try adding the '\# 0%'picture
>> switch to your mergefield. For example {MERGEFIELD ExcelData \# 0%}
>>
>> Alternatively, if Word is showing something like '0.1234' with or
>> without the percentage sign and you need it to show '12%', try
>> selecting your mergefield, pressing Ctrl-F9 to embed it in another
>> field and code the lot as: '{={MERGEFIELD ExcelData}*100 \# 0%}', or
>> '{={MERGEFIELD ExcelData}*100 \# 0.00%}' for '12.34%'.
>>
>> Cheers
>>
>> --
>> macropod
>> [MVP - Microsoft Word]
>>
>>
>> "Lica" wrote in message
>>
>>> I have a mail merge with word & excel. In the excell I have numbers
>>> with the percentage format, that it is not poplating into word.
>>> I traied to use the coding # "##%" , but it is not working. Also I
>>> cannot remove the percentage format from the excel.
>>>
>>> Thanks
Back to top
Lica
External


Since: Nov 16, 2006
Posts: 4



PostPosted: Fri Nov 17, 2006 4:22 am    Post subject: Re: Percentage format in merge from excel [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Hi Graham,

Yes, I used! I already knew abut the CTRL+F9, it is the only way to get in.

It is till not working.

"Graham Mayor" wrote:

> You didn't use CTRL+F9 to enter the curly brackets - see
> http://www.gmayor.com/formatting_word_fields.htm
>
> --
> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> Graham Mayor - Word MVP
>
> My web site www.gmayor.com
> Word MVP web site http://word.mvps.org
> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>
> Lica wrote:
> > Hi,
> >
> > thanks, but it didn't work.
> >
> > The second options id what I need, word is showing 0.123 without the
> > %. I tried the solution several times, but the result it '!Syntax
> > Error, {'.
> >
> > There is another possibility?
> >
> > Thanks!
> >
> > "macropod" wrote:
> >
> >> Hi Lica,
> >>
> >> If Word is showing something like '12.34' without the percentage
> >> sign and you need it to show '12%', try adding the '\# 0%'picture
> >> switch to your mergefield. For example {MERGEFIELD ExcelData \# 0%}
> >>
> >> Alternatively, if Word is showing something like '0.1234' with or
> >> without the percentage sign and you need it to show '12%', try
> >> selecting your mergefield, pressing Ctrl-F9 to embed it in another
> >> field and code the lot as: '{={MERGEFIELD ExcelData}*100 \# 0%}', or
> >> '{={MERGEFIELD ExcelData}*100 \# 0.00%}' for '12.34%'.
> >>
> >> Cheers
> >>
> >> --
> >> macropod
> >> [MVP - Microsoft Word]
> >>
> >>
> >> "Lica" wrote in message
> >>
> >>> I have a mail merge with word & excel. In the excell I have numbers
> >>> with the percentage format, that it is not poplating into word.
> >>> I traied to use the coding # "##%" , but it is not working. Also I
> >>> cannot remove the percentage format from the excel.
> >>>
> >>> Thanks
>
>
>
Back to top
Graham Mayor
External


Since: Aug 05, 2004
Posts: 641



PostPosted: Fri Nov 17, 2006 12:00 pm    Post subject: Re: Percentage format in merge from excel [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

The syntax error shows a left curly bracket as the problem. This implies
that you manually typed that bracket rather than use CTRL+F9

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>


Lica wrote:
> Hi Graham,
>
> Yes, I used! I already knew abut the CTRL+F9, it is the only way to
> get in.
>
> It is till not working.
>
> "Graham Mayor" wrote:
>
>> You didn't use CTRL+F9 to enter the curly brackets - see
>> http://www.gmayor.com/formatting_word_fields.htm
>>
>> --
>> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>> Graham Mayor - Word MVP
>>
>> My web site www.gmayor.com
>> Word MVP web site http://word.mvps.org
>> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>>
>> Lica wrote:
>>> Hi,
>>>
>>> thanks, but it didn't work.
>>>
>>> The second options id what I need, word is showing 0.123 without the
>>> %. I tried the solution several times, but the result it '!Syntax
>>> Error, {'.
>>>
>>> There is another possibility?
>>>
>>> Thanks!
>>>
>>> "macropod" wrote:
>>>
>>>> Hi Lica,
>>>>
>>>> If Word is showing something like '12.34' without the percentage
>>>> sign and you need it to show '12%', try adding the '\# 0%'picture
>>>> switch to your mergefield. For example {MERGEFIELD ExcelData \# 0%}
>>>>
>>>> Alternatively, if Word is showing something like '0.1234' with or
>>>> without the percentage sign and you need it to show '12%', try
>>>> selecting your mergefield, pressing Ctrl-F9 to embed it in another
>>>> field and code the lot as: '{={MERGEFIELD ExcelData}*100 \# 0%}',
>>>> or '{={MERGEFIELD ExcelData}*100 \# 0.00%}' for '12.34%'.
>>>>
>>>> Cheers
>>>>
>>>> --
>>>> macropod
>>>> [MVP - Microsoft Word]
>>>>
>>>>
>>>> "Lica" wrote in message
>>>>
>>>>> I have a mail merge with word & excel. In the excell I have
>>>>> numbers with the percentage format, that it is not poplating into
>>>>> word.
>>>>> I traied to use the coding # "##%" , but it is not working. Also I
>>>>> cannot remove the percentage format from the excel.
>>>>>
>>>>> Thanks
Back to top
Lica
External


Since: Nov 16, 2006
Posts: 4



PostPosted: Fri Nov 17, 2006 12:00 pm    Post subject: Re: Percentage format in merge from excel [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Hi all,

Thanks for the help! It is working now.

I entered with the CRTL+F9 and typed in, now I tried to start from scratch
and it worked.

Thanks a lot for your help.

"Graham Mayor" wrote:

> The syntax error shows a left curly bracket as the problem. This implies
> that you manually typed that bracket rather than use CTRL+F9
>
> --
> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> Graham Mayor - Word MVP
>
> My web site www.gmayor.com
> Word MVP web site http://word.mvps.org
> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>
>
> Lica wrote:
> > Hi Graham,
> >
> > Yes, I used! I already knew abut the CTRL+F9, it is the only way to
> > get in.
> >
> > It is till not working.
> >
> > "Graham Mayor" wrote:
> >
> >> You didn't use CTRL+F9 to enter the curly brackets - see
> >> http://www.gmayor.com/formatting_word_fields.htm
> >>
> >> --
> >> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> >> Graham Mayor - Word MVP
> >>
> >> My web site www.gmayor.com
> >> Word MVP web site http://word.mvps.org
> >> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> >>
> >> Lica wrote:
> >>> Hi,
> >>>
> >>> thanks, but it didn't work.
> >>>
> >>> The second options id what I need, word is showing 0.123 without the
> >>> %. I tried the solution several times, but the result it '!Syntax
> >>> Error, {'.
> >>>
> >>> There is another possibility?
> >>>
> >>> Thanks!
> >>>
> >>> "macropod" wrote:
> >>>
> >>>> Hi Lica,
> >>>>
> >>>> If Word is showing something like '12.34' without the percentage
> >>>> sign and you need it to show '12%', try adding the '\# 0%'picture
> >>>> switch to your mergefield. For example {MERGEFIELD ExcelData \# 0%}
> >>>>
> >>>> Alternatively, if Word is showing something like '0.1234' with or
> >>>> without the percentage sign and you need it to show '12%', try
> >>>> selecting your mergefield, pressing Ctrl-F9 to embed it in another
> >>>> field and code the lot as: '{={MERGEFIELD ExcelData}*100 \# 0%}',
> >>>> or '{={MERGEFIELD ExcelData}*100 \# 0.00%}' for '12.34%'.
> >>>>
> >>>> Cheers
> >>>>
> >>>> --
> >>>> macropod
> >>>> [MVP - Microsoft Word]
> >>>>
> >>>>
> >>>> "Lica" wrote in message
> >>>>
> >>>>> I have a mail merge with word & excel. In the excell I have
> >>>>> numbers with the percentage format, that it is not poplating into
> >>>>> word.
> >>>>> I traied to use the coding # "##%" , but it is not working. Also I
> >>>>> cannot remove the percentage format from the excel.
> >>>>>
> >>>>> Thanks
>
>
>
Back to top
macropod
External


Since: Sep 27, 2005
Posts: 994



PostPosted: Fri Nov 17, 2006 1:40 pm    Post subject: Re: Percentage format in merge from excel [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Hi Lica,

Are you sure you used '\' and not '/' to denote the picture switch?

Cheers

--
macropod
[MVP - Microsoft Word]


"Lica" wrote in message

> Hi Graham,
>
> Yes, I used! I already knew abut the CTRL+F9, it is the only way to get
in.
>
> It is till not working.
>
> "Graham Mayor" wrote:
>
> > You didn't use CTRL+F9 to enter the curly brackets - see
> > http://www.gmayor.com/formatting_word_fields.htm
> >
> > --
> > <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> > Graham Mayor - Word MVP
> >
> > My web site www.gmayor.com
> > Word MVP web site http://word.mvps.org
> > <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> >
> > Lica wrote:
> > > Hi,
> > >
> > > thanks, but it didn't work.
> > >
> > > The second options id what I need, word is showing 0.123 without the
> > > %. I tried the solution several times, but the result it '!Syntax
> > > Error, {'.
> > >
> > > There is another possibility?
> > >
> > > Thanks!
> > >
> > > "macropod" wrote:
> > >
> > >> Hi Lica,
> > >>
> > >> If Word is showing something like '12.34' without the percentage
> > >> sign and you need it to show '12%', try adding the '\# 0%'picture
> > >> switch to your mergefield. For example {MERGEFIELD ExcelData \# 0%}
> > >>
> > >> Alternatively, if Word is showing something like '0.1234' with or
> > >> without the percentage sign and you need it to show '12%', try
> > >> selecting your mergefield, pressing Ctrl-F9 to embed it in another
> > >> field and code the lot as: '{={MERGEFIELD ExcelData}*100 \# 0%}', or
> > >> '{={MERGEFIELD ExcelData}*100 \# 0.00%}' for '12.34%'.
> > >>
> > >> Cheers
> > >>
> > >> --
> > >> macropod
> > >> [MVP - Microsoft Word]
> > >>
> > >>
> > >> "Lica" wrote in message
> > >>
> > >>> I have a mail merge with word & excel. In the excell I have numbers
> > >>> with the percentage format, that it is not poplating into word.
> > >>> I traied to use the coding # "##%" , but it is not working. Also I
> > >>> cannot remove the percentage format from the excel.
> > >>>
> > >>> Thanks
> >
> >
> >
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> MailMerge Fields All times are: Eastern Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum