Merging Excel file with Word document

I

ILoveMyCorgi

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!
 
D

Doug Robbins - Word MVP

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
 
I

ILoveMyCorgi

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.
 
I

ILoveMyCorgi

I added the formatting per the link and it didn't work! Not sure how it
should look in the cell. Please help.
 
D

Doug Robbins - Word MVP

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
 
I

ILoveMyCorgi

Thank you, thank you!!! NOW I understand! I appreciate your help and I am
thankful for this resource.
Susan

Doug Robbins - Word MVP said:
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 said:
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
 
D

Doug Robbins - Word MVP

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 said:
Thank you, thank you!!! NOW I understand! I appreciate your help and I
am
thankful for this resource.
Susan

Doug Robbins - Word MVP said:
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 said:
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

message
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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top