microsoft word training courses - mailmerge number formating

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Word Training and help » microsoft word training courses - Mailmerge number formating

microsoft word training courses - Mailmerge number formating

resolvedResolved · Low Priority · Version Standard

Alistair has attended:
Excel Advanced course

Mailmerge number formating

Hi,

We are doing a mailmerge in Word using data from Excel.

The number we wish to bring accros is "735.45" but, when in Word, the number looks like "735.45000000000005". The Original data in Excel is exactly 735.45 and is not a calculation, so 735.45000000000005 is wrong.

Also I have tried playing with the Format (\*) field switch.
I added \*Arabic and got 735
I tried \*Ordinal and got 735th.

Surely there must be a format switch or whatever that puts the figure in the standard format of 000.00 (734.45).

What is it?

Cheers
ALi.

RE: Mailmerge number formating

Hi Ali

Thanks for your question.

I have run into this problem a few times - it's so annoying!

As far as I know, the following should work - let me know if not.

1. In the mail merge main document, press Alt + F9 to view the field codes. The field code will look something like {MERGEFIELD

RE: Mailmerge number formating

Perfect - Thanks.

We did a work around were we added a new column to the Excel sheet then used the formula:

=Text(C2, "0.00")

Were C2 was the original number. Then remapped the merge to this new column.


 

Word tip:

Turn Format Painter on once and use multiple times

The format painter tool provides a quick and easy way to copy formatting from one piece of text to another in Word.

The only problem is that if you click the Format Painter once to turn it on, you can only click and drag over a single piece of text; then the Format Painter turns itself off automatically.

If you want to copy formatting to more than one piece of text, double-click the Format Painter - this way you will be able to copy formatting to multiple pieces of text.

When you have finished using Format Painter, press the Esc key or click on the Format Painter button once to turn it off.

View all Word hints and tips


Server loaded in 0.08 secs.