Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Word Training and help » microsoft word training courses - Mailmerge number formating
Resolved · Low Priority · Version Standard
Alistair has attended:
Excel Advanced course
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
|
Word tip:Turn Format Painter on once and use multiple timesThe format painter tool provides a quick and easy way to copy formatting from one piece of text to another in Word. |
We'll call during UK business hours
Server loaded in 0.08 secs.