Microsoft Office Forums decimal numbers not appearing properly in merged document

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-05-2012, 11:26 AM
paulys paulys is offline decimal numbers not appearing properly in merged document Windows 7 32bit decimal numbers not appearing properly in merged document Office 2007
Novice
decimal numbers not appearing properly in merged document
 
Join Date: Aug 2012
Location: Nayarambalam, Kochi, India
Posts: 11
paulys is on a distinguished road
Default decimal numbers not appearing properly in merged document

Dear friend, while using MSWord document as main document (letter) and MS Excel file as data base (recipients) in Mail merge, the decimal number 10.50 in Excel (formatted as number with 2 decimals) appears in the merged letter as 10.49999999999999999995. Please help...Pauly
Reply With Quote
  #2  
Old 08-05-2012, 03:51 PM
macropod's Avatar
macropod macropod is offline decimal numbers not appearing properly in merged document Windows 7 64bit decimal numbers not appearing properly in merged document Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,673
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

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
[MS MVP - Word]
Reply With Quote
  #3  
Old 08-06-2012, 08:15 AM
paulys paulys is offline decimal numbers not appearing properly in merged document Windows 7 32bit decimal numbers not appearing properly in merged document Office 2007
Novice
decimal numbers not appearing properly in merged document
 
Join Date: Aug 2012
Location: Nayarambalam, Kochi, India
Posts: 11
paulys is on a distinguished road
Default

Thank you Sir, that fixed my problem. Appreciate your kindness. God bless you. Pauly Sebastian
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
decimal numbers not appearing properly in merged document Decimal alignment of numbers that use blank space as a thousands separator Aston Word 1 07-24-2012 11:44 PM
decimal numbers not appearing properly in merged document Saving merged document as separate files blankblank Mail Merge 1 05-11-2012 03:36 PM
decimal numbers not appearing properly in merged document Apostrophe-like mark appearing next to page numbers Natalie Word 2 04-26-2012 05:17 AM
Continuous page numbering in a merged document dkeinath Mail Merge 0 07-30-2010 09:30 AM
Merge, Too many Numbers right of the Decimal Point ohdearme Mail Merge 0 10-25-2009 05:10 PM


All times are GMT -7. The time now is 10:33 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