Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-28-2013, 03:12 AM
Azuki Azuki is offline How to format WORD data using edit field? Windows Vista How to format WORD data using edit field? Office 2007
Novice
How to format WORD data using edit field?
 
Join Date: Mar 2013
Posts: 2
Azuki is on a distinguished road
Default How to format WORD data using edit field?


My source data in EXCEL show 0.1. But when I merge into WORD, it show 9.15....E-2b. How can I make it show 0.1 and exactly to 1 decimal place?
Reply With Quote
  #2  
Old 03-28-2013, 01:12 PM
macropod's Avatar
macropod macropod is offline How to format WORD data using edit field? Windows 7 64bit How to format WORD data using edit field? 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

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.

Note2: If you use a decimal tab or right-aligned tab to align the values and insert a tab into the field code after the $ sign, you can have the values output like:
$ 999,999.99
$ __9,999.99
(where the _ represents the additional right-tab spacing)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 04-01-2013, 06:08 PM
Azuki Azuki is offline How to format WORD data using edit field? Windows Vista How to format WORD data using edit field? Office 2007
Novice
How to format WORD data using edit field?
 
Join Date: Mar 2013
Posts: 2
Azuki is on a distinguished road
Default

Thank you very much! It works!

Last edited by macropod; 04-01-2013 at 06:10 PM. Reason: Delete unnecessary quote of entire post replied to
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Merge field source data field kckay Mail Merge 4 03-25-2013 11:06 AM
Can't Edit Data in Word Chart Dan Reed Word 1 01-26-2012 04:25 PM
Edit Data Source- Linking template charts to new data lbf PowerPoint 0 10-28-2011 12:19 PM
Edit Multiple Emails' User-Defined Field ryancaseymcshane Outlook 0 10-04-2011 07:40 AM
Can't select or edit chart data itguy PowerPoint 2 09-19-2010 10:13 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:13 PM.


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