Skype for Business Server 2015 customers should at a minimum download and install the Skype for Business Server 2015 Cumulative Update version 9319.272 or higher. Lync Server 2013 customers should consider upgrading their installation to Skype for Business Server 2015, or downloading the latest Lync Server 2013 Cumulative Update version 8308.974 or higher. How to fix number formatting errors when using Mail Merge in Word We will do the first way to edit the Word document. Here, you will use the desired number format code for the Merge Field in the Word document.

The merge field will basically tell Word which column in the Excel table contains the data to convert. To apply formatting to a field, you must use Number Switch (formerly called Picture switch) in the field code of that field.įirst, you need to see the actual field code by opening the Mail Merge document and clicking on the Mailings tab at the top of the window. Be sure to turn off Preview Results so you can see the Mail-Merge fields. You should now see the actual field code (in curly braces as in Then, right-click on the Mail-Merge field (such as «Donation») and select the Toggle Field Code option.

Note : When adding or changing the numeric switch, the effect may not change immediately, you need to update the field by clicking on it and selecting Update Field or clicking the Mailings button > Preview Results. Sometimes you have to do this 2 or 3 times. If you use the Mail-Merge Wizard, you may have to go back to the previous steps to see the changes.

In an Excel spreadsheet, insert a column using the formula to convert the number or date in Excel to the text format you want to appear in Mail Merge.

Save time with these text formatting functions in Microsoft Excel.

To do this, we will use the TEXT function in Excel.

Nox player for mac os x el capitan