Did you ever try to use numbers in an excel spreadsheet to populate a Word document using mail merge? If you have then you probably noticed that MS Word loads any number in general format. Number formatting problems in a mail merge occur when the cells that contain the numbers in the Excel worksheet are formatted as Number, Currency, Date, Percentage, etc.
Example, $1,000.00 in Excel will load as 1000 into a mail merge document.
One way to make the number look like currency in your Mail Merge is to create a new column in excel that converts the number $1,000.00 into Text. Use the following formula: =TEXT(A1,”$#,##0.0″)
Before you use the mail merge, hard code the column with the =TEXT(A1,”$#,##0.00″) formula. When you import the new column into your mail merge document it will appear as currency.
















BlogoSquare