Percentage format in merge from excel

L

Lica

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
 
M

macropod

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
 
L

Lica

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 said:
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 said:
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
Click to expand...
Click to expand...
 
G

Graham Mayor

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

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
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 said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
L

Lica

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 said:
You didn't use CTRL+F9 to enter the curly brackets - see
http://www.gmayor.com/formatting_word_fields.htm

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
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 said:
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]


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
Click to expand...
Click to expand...
Click to expand...
 
M

macropod

Hi Lica,

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

Cheers

--
macropod
[MVP - Microsoft Word]


Lica said:
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 said:
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

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

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]


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
Click to expand...
Click to expand...
Click to expand...
 
G

Graham Mayor

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

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 said:
You didn't use CTRL+F9 to enter the curly brackets - see
http://www.gmayor.com/formatting_word_fields.htm

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


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

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]


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
Click to expand...
Click to expand...
Click to expand...
 
L

Lica

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 said:
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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

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 said:
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

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

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!

:

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]


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
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging from an Excel file with graphics 1
Merge Excel file into Word Document 3
Mail Merge Directory Conditional Page Break 0
Paste / Hyperlink multiple Excel Spreadsheets to a Mail Merge Excel Source Document 0
Anchor issue with inserting a shape for letterhead 1
Paste to excel from word - auto format problem 1
Error in formating within mail merge 2
Formatting Text from Excel 1

Top