Showing a number format in a table cell

[Guest]

I have a simple mail merge letter with a small table in it. In one of the
tables I have a number with a currency format ($ sign and two decimals).
Even though the Access Database query shows the number with the correct
currency format, when it is merged into the Word table, it will not show the
$ sign and it only shows one decimal. Checking the table format choices or
formula choices I can't find a way to change the number to the currency I
want. Is there a way in the table to change the number format?

 

[Robert M. Franz (RMF)]

Hi SR

I have a simple mail merge letter with a small table in it. In one of the
tables I have a number with a currency format ($ sign and two decimals).
Even though the Access Database query shows the number with the correct
currency format, when it is merged into the Word table, it will not show the
$ sign and it only shows one decimal. Checking the table format choices or
formula choices I can't find a way to change the number to the currency I
want. Is there a way in the table to change the number format?

Short answer:

In the connection method you've chosen from Word to the Database, Word
sees the data in the cell not the formatting. You either need to change
the connection method or add a general format switch to the MERGEFIELD
to force the formatting you need.

Long answer(s):

Date, Phone Number, and Currency fields are merged incorrectly when you
use an Access or Excel data source in Word
http://support.microsoft.com/?scid=kb;en-us;304387&x=8&y=10

Force Word to use the number format you want (by Cindy Meister)
http://homepage.swissonline.ch/cindymeister/mergfaq.htm#NumFormat

http://homepage.swissonline.ch/cindymeister/MergFram.htm

Mail Merge to E-mail with Attachments (by Doug Robbins)
http://word.mvps.org/faqs/mailmerge/MergeWithAttachments.htm

Making your mail merge "intelligent" by using IF fields (by Dave Rado)
http://word.mvps.org/FAQS/MailMerge/MMergeIfFields.htm

Greetings
Robert