formattingmail-mergemicrosoft excelmicrosoft word
When using an Excel spreadsheet as input to Word Mail Merge feature, the decimal places get all messed up:
(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!
ROUND works for me. Please make sure you used the correct column in Word. If it still doesn't work in your office version, use the TEXT function as follows:
=TEXT(A1,"0.00") (assuming the numbers are in the first column and you're inserting the formula in row 1) Using If..Then..Else is the right start as it inserts an IF field into the document which is what you need, however the dialog which comes up isn't powerful enough to do this kind of thing so you will need to edit the IF fields manually in the document.
What you will need to have is IF fields which compare the value of the field and will display the field with desired color for the appropriate value. Don't forget the MERGEFORMAT switch so that this color is passed on to the merged text.
Best Answer
Press Alt+F9 > Insert the field code
\# 0.0after the title of the merge field that needs to be limited 1 digit after the decimal point.Press Alt+F9 to hide the merge field codes.