June 26, 2013

Mail merge items show various decimal points, only 2 are needed

Problem: In Excel, mail merge option inserts decimal points with 0,xx and 0,xxxxxxx format and user wants only 0,xx

This web page helped:
Changing How Word Displays Numbers in Mail Merge
http://wordprocessing.about.com/od/usingmailmerge/qt/NPFSwitch.htm

the best solution is to include a switch in the merge field.
\#

Example:
 {MERGEFIELD "Iznos"\#--0,00x }

No comments: