Mail Merge messing decimal places

formattingmail-mergemicrosoft excelmicrosoft word

When using an Excel spreadsheet as input to Word Mail Merge feature, the decimal places get all messed up:

  • 8,1 becomes 8,0999999999999996
  • 7,0 becomes just 7

(commas are the decimal separator, and dot is the thousand separator)

Question: how to prevent this from happening again? It is tiresome to fix these errors manually!

Best Answer

Press Alt+F9 > Insert the field code \# 0.0 after the title of the merge field that needs to be limited 1 digit after the decimal point.

enter image description here

Press Alt+F9 to hide the merge field codes.

enter image description here

Related Question