#1
|
|||
|
|||
I have created an access database for my Word document. I want to see the currency number $100.00, for example, in my word document. When I merge the document, the number appears as 100. If there are cents in the number, the two decimals appear however. The access field is set up as currency for both Data Type and Format. Any ideas what I am doing wrong? I could not find in Word where I would format the mail merge field for a currency or numerical. Not sure what to do here. I have been using Word since it was invited. The date field format is working perfectly. Julie |
#2
|
||||
|
||||
See:
• Mailmerge Date Formatting • Mailmerge Percentage Formatting • Mailmerge Phone Number Formatting • Mailmerge Number & Currency Formatting • Mailmerge Time Formatting • Mailmerge US Social Security Number Formatting • Mailmerge US Zip Code Formatting in the Mailmerge Tips and Tricks Sticky threads at the top of this forum: https://www.msofficeforums.com/mail-...ps-tricks.html
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Thank you. Here are what I have tried. The first one is what the field looks like when I toggled.
{ MERGEFIELD "Rent" \# $,0.00 } { MERGEFIELD Rent \# $,0.00 } {MERGEFIELD Rent \# $,0.00} These aren't working, still showing a whole number without a Dollar sign. |
#4
|
||||
|
||||
That suggests there is content other than just the numbers in the cells concerned, or that you have mixed data types in the column concerned. If it's the former, you may be able to resolve the issue by enclosing the mergefield in a formula field, thus:
{=«Rent» \# $,0.00 } or: {={ MERGEFIELD Rent } \# $,0.00} The mixed data issue, too, is discussed in the Mailmerge Tips and Tricks sticky thread.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Problem with currency field code | DIYman | Mail Merge | 2 | 09-22-2015 12:16 AM |
Showing reosurce and work in same field | JonHarding | Project | 3 | 08-17-2014 12:41 PM |
Field not showing in Pivot Table Field List | kmcovington | Excel | 0 | 10-26-2012 10:14 AM |
currency not showing correctly on mail merge | tonywatsonmail | Mail Merge | 1 | 12-07-2011 04:29 PM |
TOC Level 3 Field Not Showing Up (Word 2007) | freitag | Word | 1 | 01-26-2010 08:47 PM |