Prev: Spell chekc not working in word tables
Next: Text will not replace word after highlighting and paste
From: ILoveMyCorgi on 21 May 2010 19:54
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 21 May 2010 20:39
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: ILoveMyCorgi on 22 May 2010 20:30
Not sure what to look for on your web page. I just need to know how to
format currency on the Word side so that when I merge the Excel data [field
already is in currency] it translates to currency also.

"Doug Robbins - Word MVP" wrote:

> 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: ILoveMyCorgi on 22 May 2010 21:26
I added the formatting per the link and it didn't work! Not sure how it
should look in the cell. Please help.

"Doug Robbins - Word MVP" wrote:

> 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 22:34
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!
>
 |  Next  |  Last
Pages: 1 2
Prev: Spell chekc not working in word tables
Next: Text will not replace word after highlighting and paste