Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Showing a number format in a table cell
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? -- SR |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Showing a number format in a table cell
Hi SR
SR wrote: 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=k...04387&x=8&y=10 Force Word to use the number format you want (by Cindy Meister) http://homepage.swissonline.ch/cindy....htm#NumFormat http://homepage.swissonline.ch/cindy...r/MergFram.htm Mail Merge to E-mail with Attachments (by Doug Robbins) http://word.mvps.org/faqs/mailmerge/...ttachments.htm Making your mail merge "intelligent" by using IF fields (by Dave Rado) http://word.mvps.org/FAQS/MailMerge/MMergeIfFields.htm Greetings Robert -- /"\ ASCII Ribbon Campaign | MS \ / | MVP X Against HTML | for / \ in e-mail & news | Word |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cell number format | Tables | |||
Change number of column in an individual cell in a table | Tables | |||
Table Cell Number Format | New Users | |||
how do I set up number formating in a cell of a table, ie, $1.00? | Tables | |||
Word Table format need circle around text but not to expand cell | Tables |