When mail merging numeric data, too many decimal places appear in the Word document.This is a featured page


  1. While viewing the mail merge file (in Word), right-click on the merge field representing the numeric data. Select Edit Field.
  2. Click the Field Code button near the bottom of the window.
  3. Under Advanced Field Properties (on the right), find the edit line that reads:
    MERGEFIELD <yourfieldname>
  4. After the name of the field, type: \# 0.00 ( \# 0.000 for 3 decimal places, etc.)
  5. Click OK.


bulljohn
bulljohn 		Latest page update: made by bulljohn , Jan 10 2008, 3:01 PM EST (about this update About This Update bulljohn Edited by bulljohn


view changes
- complete history)
Keyword tags: excel mail merge office
More Info: links to this page

Threads for this page

There are no threads for this page.  Be the first to start a new thread.

Related Content

  (what's this?Related ContentThanks to keyword tags, links to related pages and threads are added to the bottom of your pages. Up to 15 links are shown, determined by matching tags and by how recently the content was updated; keeping the most current at the top. Share your feedback on Wetpaint Central.)
Microsoft Office Applications PowerPoint Merge slides into an existing PowerPoint presentation
Make a Photo Album in PowerPoint Excel Word
Create a Mail Merge Adding a speech balloon Changing the default font