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.

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 “fieldname” }

2. Directly after the end quote around the field name, leave a space then type \# "0.00" inside the }

3. Once you have added your field switch, press Alt + F9 to display the fields instead of the field codes

4. If the number doesn't display correctly straight away, save, close and reopen it.

Amanda

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.