Quick Links ▼

Bookmark page

Printable version

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Mail merge using Excel

	98.1 % recommend us
	More live stats...

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

Training information:

Mail merge using Excel

Resolved · Medium Priority · Version 2003

Reply Fri 13 Nov 2009, 15:53Delegate Deirdre said...

Deirdre has attended:
Excel Advanced course

Mail merge using Excel

Hello,

I'm trying to use mail-merge to compile a large group of letters. One of the columns contains amounts of money. This column is formatted to have two decimal places on excel.

When I carry out the merge, numbers where the second decimal place is 0 are coming through in the format XX.X rather than XX.XX.

Can you tell me how to ensure that numbers come through in the formal XX.XX?

Thanks

Deirdre

For upcoming training course dates see: Pricing & availability

Reply Wed 18 Nov 2009, 13:25Trainer Simon said...

RE: Mail merge using Excel

Hi Deirdre,

Thank you for your question.

I am currently looking at the question it in my breaks and lunch and have not found a way to ensure the format stays the same.

As soon as I find a solution, I will email you.

Regards

Simon

Reply Tue 24 Nov 2009, 00:52Trainer Simon said...

RE: Mail merge using Excel

Hi Dierdre,

Sorry for the delay in responding.

Have you managed to resolve your problem?

I have found a possible solution. Please try this:

1. Add the mail merge fields.
2. Use Alt + F9 to show the merge codes
3. e.g. {MERGEFIELD "Fieldname" }
4. Change the code for the cash field to this:
5. {MERGEFIELD "Fieldname"\#0.00x}

This should format the cash field to show two decimal places.

I hope this answers your question.

Regards

Simon

Excel articles

· Find Out Your Age In Days With Excel
· Importing Excel Data Into Access
· How Teachers Are Using Microsoft Excel To Enhance Learning in the Classroom
· Microsoft Excel Training Courses or Consultants: Which Is Better For Your Company?
· Reasons Why VBA for Excel Training Fails

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

Excel tip:

Highlighting a data range

Attempting to use a mouse to highlight a large range of cells with data in Excel can make the mouse to have a life of it's own!

Use keyboard strokes instead.

Step 1. Place the cusor in the cell where the highlighting should begin.

Step 2. Select keystroke, CTRL+SHIFT+END

This will take the cursor to the furthermost bottom corner of the data range found in that worksheet. And highlight that range of cells at the same time

View all Excel hints and tips