Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #7   Report Post  
abureem abureem is offline
Junior Member
 
Posts: 1
Smile

hope this isn't late, any how try the following steps, I try it & it worked;

. With the mail merge main document open, press Alt + F9 to view the field codes

2. The field code will look something like {MERGEFIELD “fieldname” }

3. Directly after the end quote around the field name type \# -- do not add spaces or quotes

4. Directly after the field switch you just entered, type 0.0x if you want to round the number to two decimal places, 0.00x if you want to round the number to three decimal places and so forth

5. Once you have added your field switch, press Alt + F9 to display the fields instead of the field codes


Your number will appear rounded to the decimal place you specify; if it does not display immediately, refresh the document by minimizing it to the toolbar and reopening. If the field value still does not display correctly, you may need to refresh the document again or close and re-open your document.
 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Round numbers to 2 decimal places when using Word Mail Merge ALJ Mailmerge 3 April 30th 23 02:49 PM
Round Down Merge field Niall Mailmerge 2 August 19th 13 09:05 PM
How can you round a number in a non-calculating field? Jerye Microsoft Word Help 7 June 18th 09 05:05 AM
Moving addresses round on mail merge labels? dafttart100 Mailmerge 3 May 23rd 06 05:55 PM
sort mail merge by merge record number nathan Mailmerge 1 August 10th 05 07:09 AM


All times are GMT +1. The time now is 11:06 PM.

Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"