InIT Software Training Blog – On Course for Success

mailmerge

Import Currency Format to Word from Excel

Import Currency Format

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Often I get asked how to import the currency format from Excel to Word as a straight forward mail-merge import loses the formatting. The formatting is carried out within Word by formatting the field within the document. The three currency fields in this example do not have the £ symbol and do not have two decimal places.

You can display the field codes by clicking the Preview Results command on the Mailing ribbon tab.

Now right click on the field code you wish to format
Select Toggle Field Codes

Place your insertion point at the end of the code but before the }

Type \# £##,00    

note the space before and after \#