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

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
microsoft word training courses - mailmerge number formating

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

ResolvedVersion 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:

Inches to Centimenters and Back

Set up in inches and want to work in centimeters or the other way round?
Select Tools, Options and choose the General Tab, click the drop-down arrow next to the text box displaying 'Inches' and choose Centimeters. Note there are two other options Picas and Points these are Printer's terms, (72 points = 1 inch in printed size.)

View all Word hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.