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

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

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

No comments: