Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Merging Excel file with Word document
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! |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Merging Excel file with Word document
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" wrote in 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! |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Merging Excel file with Word document
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" wrote in 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! |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Merging Excel file with Word document
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" wrote in 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! |
#5
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Merging Excel file with Word document
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" wrote in message ... 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" wrote in 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! |
#6
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Merging Excel file with Word document
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" wrote in message ... 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" wrote in 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! |
#7
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Merging Excel file with Word document
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" wrote in message news 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" wrote in message ... 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" wrote in 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! |
#8
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Merging Excel file with Word document
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" wrote in message news 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" wrote in message ... 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" wrote in 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! |
#9
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Merging Excel file with Word document
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" wrote in message ... 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" wrote in 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! |
#10
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Merging Excel file with Word document
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" wrote in 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! |
#11
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Merging Excel file with Word document
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" wrote in 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! |
#12
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Merging Excel file with Word document
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" wrote in message ... 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" wrote in 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! |
#13
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Merging Excel file with Word document
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" wrote in 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! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem merging Word 2003 with Excel file | Mailmerge | |||
Merging from an excel file into a word table | Mailmerge | |||
Merging Word with a mutiple sheets Excel file | Mailmerge | |||
Mail Merging using word browsing excel file. | Mailmerge | |||
Merging Excel File into Word | Mailmerge |