Microsoft Office Forums Currency Field not showing $ and is rounding

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-02-2016, 02:07 PM
Juliesctt Juliesctt is offline Currency Field not showing $ and is rounding Windows 7 64bit Currency Field not showing $ and is rounding Office 2013
Novice
Currency Field not showing $ and is rounding
 
Join Date: Jul 2016
Posts: 2
Juliesctt is on a distinguished road
Default

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
Reply With Quote
  #2  
Old 07-03-2016, 10:52 AM
macropod's Avatar
macropod macropod is offline Currency Field not showing $ and is rounding Windows 7 64bit Currency Field not showing $ and is rounding Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,533
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

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
[MS MVP - Word]
Reply With Quote
  #3  
Old 07-03-2016, 01:02 PM
Juliesctt Juliesctt is offline Currency Field not showing $ and is rounding Windows 7 64bit Currency Field not showing $ and is rounding Office 2013
Novice
Currency Field not showing $ and is rounding
 
Join Date: Jul 2016
Posts: 2
Juliesctt is on a distinguished road
Default

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.
Reply With Quote
  #4  
Old 07-05-2016, 06:43 PM
macropod's Avatar
macropod macropod is offline Currency Field not showing $ and is rounding Windows 7 64bit Currency Field not showing $ and is rounding Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,533
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

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
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Currency Field not showing $ and is rounding Problem with currency field code DIYman Mail Merge 2 09-22-2015 12:16 AM
Currency Field not showing $ and is rounding 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 Field not showing $ and is rounding 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


All times are GMT -7. The time now is 10:23 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft