Percentage format in merge from excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lica - 16 Nov 2006 12:05 GMT

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

Reply to this Message

macropod - 16 Nov 2006 12:22 GMT

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

Signature

macropod
[MVP - Microsoft Word]

> 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

Reply to this Message

Lica - 16 Nov 2006 13:36 GMT

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!

> Hi Lica,
>
[quoted text clipped - 17 lines]
> >
> > Thanks

Reply to this Message

Graham Mayor - 16 Nov 2006 14:57 GMT

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

Signature

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

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

> Hi,
>
[quoted text clipped - 32 lines]
>>>
>>> Thanks

Reply to this Message

Lica - 16 Nov 2006 16:47 GMT

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.

> You didn't use CTRL+F9 to enter the curly brackets - see
> http://www.gmayor.com/formatting_word_fields.htm
[quoted text clipped - 35 lines]
> >>>
> >>> Thanks

Reply to this Message

macropod - 16 Nov 2006 21:40 GMT

Hi Lica,

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

Cheers

Signature

macropod
[MVP - Microsoft Word]

> Hi Graham,
>
[quoted text clipped - 41 lines]
> > >>>
> > >>> Thanks

Reply to this Message

Graham Mayor - 17 Nov 2006 05:00 GMT

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

Signature

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

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

> Hi Graham,
>
[quoted text clipped - 51 lines]
>>>>>
>>>>> Thanks

Reply to this Message

Lica - 17 Nov 2006 11:30 GMT

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.

> The syntax error shows a left curly bracket as the problem. This implies
> that you manually typed that bracket rather than use CTRL+F9
[quoted text clipped - 54 lines]
> >>>>>
> >>>>> Thanks

Reply to this Message