Mail merge and decimals (2003)

Topic

New Reply

I am trying to merge examination results from an excel workbook as a mail merge in Word 2003. The merge works well except that the merge field contains many decimal places whereas I require the nearest whole number. I have formatted the data in Excel every way I can think of but the decimal problem still persists. I have browsed for solutions and have attempted the use of switches to no avail. I presume I’m not applying the correct switches. Any help would be appreciated.

Reply | Quote

Replies

Hey Bandido… long time no speak!!

Try these two links. I’m sure they will correct your error…

http://wordprocessing.about.com/od/usingma…t/NPFSwitch.htm%5B/url%5D
http://kb.seattleu.edu/oit/article.aspx?id=10316%5B/url%5D

Reply | Quote

Happy new year, Rob!

Also see post 641,008.

For whole numbers, you can use the switch

# "0"

or if you would like to include the thousands separator

# "#,##0"

Reply | Quote

Happy New Year to you all.

I still cannot get it to work. I must be applying the switches incorrectly. After toggling field codes and inserting the switch, this is how it appears:

{MERGEFIELD “AutoMergeField”/# “0” }

What am I doing wrong?

Many thanks

Reply | Quote

You need to use a backslash, and I’d insert a space before it:

{ MERGEFIELD "AutoMergeField" # "0" }

Reply | Quote

Hi Hans

Still no joy. I’ve included a before and after screen shot. I must be doing something very silly!

Reply | Quote

Have you updated the field (F9) or actually performed the mail merge?

Reply | Quote

. It’s working. Thanks so much, Hans (and of course, Rudi.)

Reply | Quote

Hans –

As usual, you had the answer for a problem that has been causing me to tear my hair out. Thanks so much, not only from me, but also from my hairdresser and my husband.

Lee Morgan

Reply | Quote