microsoft word training courses - mailmerge number formating
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

replyReply Thu 31 May 2007, 14:01Delegate Alistair said...

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.

For upcoming training course dates see: Pricing & availability

replyReply Fri 1 Jun 2007, 15:03Trainer Amanda said...

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

replyReply Fri 1 Jun 2007, 15:10Delegate Alistair said...

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:

Assign shortcut keys to styles

If you're a fan of using styles, you can create your own shortcut keys to apply styles quickly.

Go to Tools - Customise, then to the Options tab. Click on the Keyboard button on this tab.

Scroll down the list displayed on the left, until you see Styles. Click on Styles to select it, then you will see a list of styles currently available for use on the right.

If a style you wish to assign a shortcut key to does not appear in the list on the right, close out of the dialogue box, apply the style, then follow the steps above again - you should then see the style listed.

Enter your shortcut key combination in the 'Press new shortcut key' box. If the shortcut keys selected are already assigned to another function in Word, it will be displayed in the box.

If you want to overwrite the existing function for the shortcut keys you have chosen, click Assign.

If you wish to assign a unique set of shortcut keys, use Backspace to remove the shortcut keys you have typed in; then try typing in another key combination. Click Assign when you have a key combination you are happy with.

View all Word hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard