Excel | Word | PowerPoint | Outlook | Milton Keynes | Rugby | Northampton

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.

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

Achieve for Success – Learning for Success – Progress for Success – Training for Success – Planning for Success – Develop for Success

Milton Keynes Chamber Member

InIT Learning Computer Courses Milton Keynes

0330 32 100 58


 

Simple Pricing Structureslidecbc63a156cc04de8813a463a020004cc1Courses @ Yours
£640.00 per course of 3-8
£428.00 per course of 2
£258.00 One to One
(Plus Travel @ 45p/mile)

Scheduled Courses
@ Ours
£129.00 per delegate

1 to 1 Courses
@ Ours
£258.00 per delegate


InIT Learning
Harben House Business Centre
Tickford Street
Newport Pagnell
MK16 9EY

01908 92 50 58

0330 32 100 58