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
Resolved · 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.
For upcoming training course dates see: Pricing & availability
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.
|
