Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-07-2011, 07:29 AM
tonywatsonmail tonywatsonmail is offline currency not showing correctly on mail merge Windows 7 32bit currency not showing correctly on mail merge Office 2007
Novice
currency not showing correctly on mail merge
 
Join Date: Jun 2011
Posts: 10
tonywatsonmail is on a distinguished road
Unhappy currency not showing correctly on mail merge

Hi everyone,

can someone please give me what i need to change my current mailmerge code so that my field comes in as £ 1,000.00 and not just 1000 as it does now!

thanks

Tony
Reply With Quote
  #2  
Old 12-07-2011, 04:29 PM
macropod's Avatar
macropod macropod is offline currency not showing correctly on mail merge Windows 7 64bit currency not showing correctly on mail merge Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi Tony,

To control number & currency formatting in Word, add a numeric picture switch to the mergefield. To do this:
• select the field;
• press Shift-F9 to reveal the field coding. It should look something like {MERGEFIELD MyData};
• edit the field so that you get {MERGEFIELD MyData \# £,0.00} (or whatever other numeric format you prefer - see below);
• position the cursor anywhere in this field and press F9 to update it;
• run your mailmerge.
Note1: The '\# £,0.00' in the field is referred to as a numeric picture switch. Other possibilities include:
. \# 0 for rounded whole numbers
. \# ,0 for rounded whole numbers with a thousands separator
. \# ,0.00 for numbers accurate to two decimal places, with a thousands separator
. \# £,0 for rounded whole dollars with a thousands separator
. \# "£,0.00;(£,0.00);'-'" for currency, with brackets around negative numbers and a hyphen for 0 values
The precision of the displayed value is controlled by the '0.00'. You can use anything from '0' to '0.000000000000000'.
If you use a final ';' in the formatting switch with nothing following, (eg \# "£,0.00;(£,0.00);") zero values will be suppressed. Note that this suppresses 0s resulting from empty fields and from fields containing 0s.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
currency not showing correctly on mail merge Saving INDV mail merges During the mail merge sedain121 Mail Merge 2 10-04-2011 07:52 PM
currency not showing correctly on mail merge Date not transfering to mail merge correctly tonywatsonmail Mail Merge 1 07-01-2011 05:30 AM
Formatting Cells for Currency and Accounting Sparetyme Excel 1 07-11-2010 01:26 PM
Unread mail not showing up in Inbox - Outlook 2007 ayaz_rn@hotmail.com Outlook 0 04-30-2009 11:32 AM
currency not showing correctly on mail merge change currency $ to £ on excel invoice help deanorx7 Excel 3 07-08-2008 04:40 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:08 AM.


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