#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
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] |
#3
|
|||
|
|||
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. |
#4
|
||||
|
||||
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] |
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 |
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 |