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.

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


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

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