Prev: Spell chekc not working in word tables
Next: Text will not replace word after highlighting and paste
From: ILoveMyCorgi on 22 May 2010 23:22
Thank you, thank you!!! NOW I understand! I appreciate your help and I am
thankful for this resource.
Susan

"Doug Robbins - Word MVP" wrote:

> In the Mail Merge main document, press Alt+F9 to toggle on the display of
> the field codes and go to the field that contains the currency amount and
> you will see
>
> { MERGEFIELD [fieldname] }
>
> where [fieldname] is the name of the field in your data source.
>
> Inside the closing }, insert the following switch
>
> \# "$,0.00"
>
> or if you have negative amounts that you want to place in parentheses, use
>
> \# "$,0.00;($,0.00)"
>
> so that you have
>
> { MERGEFIELD [fieldname] \# "$,0.00" }
>
> or
>
> { MERGEFIELD [fieldname] \# "$,0.00;($,0.00)" }
>
> Use Alt+F9 again to toggle off the display of the field codes and then
> execute your merge.
>
> --
> Hope this helps.
>
> Please reply to the newsgroup unless you wish to avail yourself of my
> services on a paid consulting basis.
>
> Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
>
> "Doug Robbins - Word MVP" <dkr(a)REMOVECAPSmvps.org> wrote in message
> news:C3D13FF6-5A14-4BA6-9888-E30F0361564F(a)microsoft.com...
> > See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
> > website at :
> >
> > http://www.gmayor.com/formatting_word_fields.htm
> >
> >
> > --
> > Hope this helps.
> >
> > Please reply to the newsgroup unless you wish to avail yourself of my
> > services on a paid consulting basis.
> >
> > Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
> >
> > "ILoveMyCorgi" <ILoveMyCorgi(a)discussions.microsoft.com> wrote in message
> > news:3A1FF199-4E70-4FC1-B079-E50F9423480A(a)microsoft.com...
> >> I am merging quite a bit of data and the fields that have currency are
> >> not
> >> formatting correctly. The merge takes place inside a table cell and some
> >> format without the dollar sign. I have changed the formatting to number
> >> with
> >> two decimal places and when I merge I get lots of zeroes after the
> >> decimal
> >> ending in 3. What am I doing wrong????? This is driving me crazy!
> >
From: Doug Robbins - Word MVP on 22 May 2010 23:37
You're welcome.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"ILoveMyCorgi" <ILoveMyCorgi(a)discussions.microsoft.com> wrote in message
news:D143D59C-BDCD-4CCC-A229-CBD767429B50(a)microsoft.com...
> Thank you, thank you!!! NOW I understand! I appreciate your help and I
> am
> thankful for this resource.
> Susan
>
> "Doug Robbins - Word MVP" wrote:
>
>> In the Mail Merge main document, press Alt+F9 to toggle on the display of
>> the field codes and go to the field that contains the currency amount and
>> you will see
>>
>> { MERGEFIELD [fieldname] }
>>
>> where [fieldname] is the name of the field in your data source.
>>
>> Inside the closing }, insert the following switch
>>
>> \# "$,0.00"
>>
>> or if you have negative amounts that you want to place in parentheses,
>> use
>>
>> \# "$,0.00;($,0.00)"
>>
>> so that you have
>>
>> { MERGEFIELD [fieldname] \# "$,0.00" }
>>
>> or
>>
>> { MERGEFIELD [fieldname] \# "$,0.00;($,0.00)" }
>>
>> Use Alt+F9 again to toggle off the display of the field codes and then
>> execute your merge.
>>
>> --
>> Hope this helps.
>>
>> Please reply to the newsgroup unless you wish to avail yourself of my
>> services on a paid consulting basis.
>>
>> Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
>>
>> "Doug Robbins - Word MVP" <dkr(a)REMOVECAPSmvps.org> wrote in message
>> news:C3D13FF6-5A14-4BA6-9888-E30F0361564F(a)microsoft.com...
>> > See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
>> > website at :
>> >
>> > http://www.gmayor.com/formatting_word_fields.htm
>> >
>> >
>> > --
>> > Hope this helps.
>> >
>> > Please reply to the newsgroup unless you wish to avail yourself of my
>> > services on a paid consulting basis.
>> >
>> > Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
>> >
>> > "ILoveMyCorgi" <ILoveMyCorgi(a)discussions.microsoft.com> wrote in
>> > message
>> > news:3A1FF199-4E70-4FC1-B079-E50F9423480A(a)microsoft.com...
>> >> I am merging quite a bit of data and the fields that have currency are
>> >> not
>> >> formatting correctly. The merge takes place inside a table cell and
>> >> some
>> >> format without the dollar sign. I have changed the formatting to
>> >> number
>> >> with
>> >> two decimal places and when I merge I get lots of zeroes after the
>> >> decimal
>> >> ending in 3. What am I doing wrong????? This is driving me crazy!
>> >
First  |  Prev  | 
Pages: 1 2
Prev: Spell chekc not working in word tables
Next: Text will not replace word after highlighting and paste