Although these codes are identical to the code used in Excel's Custom Number formatting feature, most users rarely see them.įor example : The formulas TEXT (B3, '$ #, # 0.00') and TEXT (C5, 'M / dd / yy') convert numbers and dates into text (in this case the conversion will become '$ 12,345.67' and '12 / 01/10 '. However, this method has a disadvantage that you need to know certain format codes. This function has the function of converting numbers or dates into the corresponding text format.
![how to print address labels in word merging excel fields how to print address labels in word merging excel fields](https://www.addictivetips.com/app/uploads/2010/03/new.jpg)
To do this, we will use the TEXT function in Excel.
![how to print address labels in word merging excel fields how to print address labels in word merging excel fields](https://cdn.ablebits.com/_img-blog/mail-merge/select-table.png)
Here, you will use the desired number format code for the Merge Field in the Word document. We will do the first way to edit the Word document.
How to print address labels in word merging excel fields how to#
How to fix number formatting errors when using Mail Merge in Word