Mailmerge from Excel my numbers do not stay as 2 decimals. Help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

M.Darlene - 28 Jul 2005 23:33 GMT

Numbers in my Word mailmerge from Excel after upgrading do not show the cents
(.00) if the number is even, and if in it isn't a whole number it may show up
as 34.999666. How do it get it to merge as just a number with 2 decimal
places?

Reply to this Message

MeDog - 29 Jul 2005 02:59 GMT

This site will have the answer you want (and more)

http://www.gmayor.com/formatting_word_fields.htm

Regards,

John A

Melbourne Australia

> Numbers in my Word mailmerge from Excel after upgrading do not show the
> cents
> (.00) if the number is even, and if in it isn't a whole number it may show
> up
> as 34.999666. How do it get it to merge as just a number with 2 decimal
> places?

Reply to this Message