Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-22-2013, 02:52 PM
Abacus1234 Abacus1234 is offline in 2013, cannot format 4 dec places in Word Document Windows Vista in 2013, cannot format 4 dec places in Word Document Office 2010 32bit
Novice
in 2013, cannot format 4 dec places in Word Document
 
Join Date: Nov 2011
Posts: 24
Abacus1234 is on a distinguished road
Default in 2013, cannot format 4 dec places in Word Document

Using an application with word and access. My access table has a field type of double with 4 decimal places. I see 4 decimal places in the underlying data.

I have not been able to format the merge field in the word document to show 4 decimal places. example Mergefield InterestRate\#0.0000

I am exporting a query into a txt file before doing the mail merge.
Reply With Quote
  #2  
Old 10-23-2013, 04:52 AM
macropod's Avatar
macropod macropod is offline in 2013, cannot format 4 dec places in Word Document Windows 7 32bit in 2013, cannot format 4 dec places in Word Document 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

A mergefield coded as {Mergefield InterestRate \# 0.0000} will show the data to 4 decimal places. If you're dealing with percentage data, though, you may need to multiply the values by 100 to get the results you're after.

To control the percentage formatting in Word, rather than at the data source, add a formula and numeric picture switch to the mergefield, as follows:
• select your mergefield, which will look something like «InterestRate»;
• press Ctrl-F9 to wrap another field around it, thus { «InterestRate» };
• edit the field so that you get {=«InterestRate»*100 \# 0.00%};
• position the cursor anywhere in this field and press F9 to update it;
• run your mailmerge.

Note1: the precision of the displayed value is controlled by the '0.00'. You can use anything from '0' to '0.000000000000000'.

Note2: The field brace pairs (ie '{ }') for the above example are created in the body of the document via Ctrl-F9 (Cmd-F9 on a Mac) - you can't simply type them or copy & paste them from this message. Likewise, you can't type or copy & paste the chevrons (ie '« »') - they're part of the actual mergefields, which you can insert from the mailmerge toolbar.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 10-23-2013, 06:34 AM
Abacus1234 Abacus1234 is offline in 2013, cannot format 4 dec places in Word Document Windows Vista in 2013, cannot format 4 dec places in Word Document Office 2010 32bit
Novice
in 2013, cannot format 4 dec places in Word Document
 
Join Date: Nov 2011
Posts: 24
Abacus1234 is on a distinguished road
Default

Paul,

I am using the example above. But when you add 0 to extend the decimal places, it does not provide additional numbers, it adds additional 0. I haven't checked yet but I am wondering if when the query is exported to the .txt file it somehow drops the extra numbers. This is an issue in 2013.

In this particular example, the data is not being used for calculation, so my solution is to make the field a short text and it keeps whatever is put in there.

Thanks for your help.
Reply With Quote
  #4  
Old 10-23-2013, 03:57 PM
macropod's Avatar
macropod macropod is offline in 2013, cannot format 4 dec places in Word Document Windows 7 32bit in 2013, cannot format 4 dec places in Word Document 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

With one exception, regardless of the content of your data source, the switch should display the data to 4 decimal places. That exception is if the data source uses something other than a period as the decimal separator.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Word Documents appear in two places Drjh68 Word 1 08-25-2013 03:19 PM
Word 2013 file opens as WD00000x and in 97 - 2003 format duncanwil Word 0 07-23-2013 10:51 PM
Format/Size of the Word Document colinito Word 2 04-25-2013 01:33 AM
in 2013, cannot format 4 dec places in Word Document format a Microsoft Word Document, and need your help! taylorr Word 1 02-16-2013 01:54 AM
Which ODF/ .odt version is word 2010, 2013 preview & eventually 2013 full using? semiotically Word 8 11-08-2012 05:44 PM

Other Forums: Access Forums

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