Problem with percents

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dale - 19 Mar 2006 17:41 GMT

I work at a school. Our secretary has a list of students who are
frequently tardy in an Excel file. One of the columns is the percent of
days the child is tardy. She wants to merge this file into a Word 2003
file. The merging went fine, but when the percent is merged into Word,
the percent is now a decimal. How do I format the Word document to show
percent, not a decimal? Thanks so much.

Reply to this Message

Doug Robbins - Word MVP - 19 Mar 2006 17:56 GMT

In the mail merge main document, press Alt+f9 to display the field codes.
Then modify it to the following

{ = { MERGEFIELD [fieldname] } * 100 \# "0.0%" }

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm

Signature

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

>I work at a school. Our secretary has a list of students who are frequently
>tardy in an Excel file. One of the columns is the percent of days the child
>is tardy. She wants to merge this file into a Word 2003 file. The merging
>went fine, but when the percent is merged into Word, the percent is now a
>decimal. How do I format the Word document to show percent, not a decimal?
>Thanks so much.

Reply to this Message