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