Call: 0330 32 100 58

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.

Mail Merge Excel currency format to Word

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.

Mail Merge Excel currency format to Word

Now right click on the field code you wish to format

Mail Merge Excel currency format to Word

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 \#

On Course for Success with InIT Learning
On Course to Develop - On Course to Progress - On Course to Achieve
InIT Learning One day Computer Courses
Copyright © InIT Learning
Areas Covered - Milton Keynes, Buckinghamshire - Northampton, Northamptonshire - Rugby, Warwickshire - Oxford, Oxfordshire - Bedford, Bedfordshire - All surrounding towns and counties
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close