Currency format lost when merging into Word
in [Document Management]
|
Prev: Go from 2 spaces to 1 after the period using Office 2007
Next: Control Toolbox toolbar keeps coming back
From: Lyn on 9 Feb 2010 12:16 I am doing a mail merge and have 3 merge fields that contain numbers. I have formatted them as currency and as number with 2 decimal points, but no matter how I do it, it throws in a number of zeros. For example, $376.18 is merging into the document as $376.18000000000001. In every field it is adding 11 zeros and another number at the end.
From: Suzanne S. Barnhill on 9 Feb 2010 16:39
See http://www.gmayor.com/formatting_word_fields.htm -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "Lyn" <Lyn(a)discussions.microsoft.com> wrote in message news:756883C8-0256-4881-966C-8065F7FCA119(a)microsoft.com... >I am doing a mail merge and have 3 merge fields that contain numbers. I >have > formatted them as currency and as number with 2 decimal points, but no > matter > how I do it, it throws in a number of zeros. For example, $376.18 is > merging > into the document as $376.18000000000001. In every field it is adding 11 > zeros and another number at the end. > |