Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Exporting formatted data to Word mail merge

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Exporting formatted data to Word mail merge

Resolved · Low Priority · Version 2003

Reply Thu 18 Nov 2010, 15:39Delegate Thomas said...

Thomas has attended:
Excel Introduction course

Exporting formatted data to Word mail merge

How can I export formated data with zero decimel place from Excel into a Word mailmerge document so that it retains the zero decimel places. Currently Word puts back the default two deceimel places.

For upcoming training course dates see: Pricing & availability

Reply Mon 22 Nov 2010, 10:13Trainer Stephen said...

RE: Exporting formatted data to Word mail merge

Hi Thomas

Thanks for your question

As discussed I have passed this question over to a colleague with better knowledge of word mail merge than my self

Regards

Stephen

Reply Mon 22 Nov 2010, 15:59Trainer Simon said...

RE: Exporting formatted data to Word mail merge

Hi Thomas,

Thank you for your question and welcome to the forum.

In the Word document can you reveal the Merge Field codes by using ALT+F9. Edit the merge field containing the data. It will probably look something like this:

{MERGEFIELD "Salary"}

For your predicament try:

{MERGEFIELD Salary\#,##0}

The line above means number format followed by 0 decimal places.

If you edit the field code as below, it will give you the currency symbol followed by two decimal places.

{MERGEFIELD Salary\#£#,##0.00}

I hope this answers your question.

Regards

Simon

Mon 29 Nov 2010: Automatically marked as resolved.

Excel articles

· Microsoft Excel as a Reporting Tool
· Crazy Things People Have Done With Excel
· Using Excel In Any Condition
· Employing Cell References in Excel
· Data Validation In Excel: Not As Daunting As It Sounds

Please browse our web site to find out more about
excel consulting and other Microsoft training courses.

Excel tip:

Using the Quick Access Toolbar in Excel2010

The Quick Access Toolbar is included in virtually every Office product, including Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010.

You will find the Quick Access Toolbar in the top-left side of the window. To begin, click the Customize button (it's the little black arrow at the end of the toolbar).

Simply click the commands you want to include.

Virtually any command can be added to the Quick Access Toolbar. Click the More Commands option and a new window will open from where you can browse the commands including those not on the ribbon.

View all Excel hints and tips