Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.word.tables
|
|||
|
|||
![]()
I am working with a table in Microsoft Word 2007. I have figured out how to
add up a certain number of cells and do a sum and have that formatted for currency. My question is that the cells that are in the formula (B1+B2+B3, etc.) do not appear as currency. How can I format the entry cells for currency? Thank you for you advice in advance. |
#2
![]()
Posted to microsoft.public.word.tables
|
|||
|
|||
![]()
Hi dbalorenzini,
You can do this by adding a numeric picture switch to the SUM field. To do this: .. select the field; .. press Shift-F9 to reveal the field coding. It should look something like {=SUM(B1:B3)} (note that you don't need to specify each cell in a spanned range); .. edit the field so that you get {=SUM(B1:B3) \# $,0.00} (or whatever other numeric format you prefer - see below); .. position the cursor anywhere in this field and press F9 to update it; .. run your mailmerge. Note: The '\# 0' in the field is referred to as a numeric picture switch. Other possibilities include: .. \# 0 for rounded whole numbers .. \# ,0 for rounded whole numbers with a thousands separator .. \# ,0.00 for numbers accurate to two decimal places, with a thousands separator .. \# $,0 for rounded whole dollars with a thousands separator .. \# $,0.00;($,0.00);- for currency, with brackets around negative numbers and a hyphen for 0 values The precision of the displayed value is controilled by the '0.00'. You can use anything from '0' to '0.000000000000000'. If you use a final ';' in the formatting switch with nothing following, (eg \# $,0.00;($,0.00) ![]() Note that this suppresses 0s resulting from empty fields and from fields containing 0s. For more information on doing calculations in Word, check out my Word Field Maths Tutorial, at: http://www.wopr.com/index.php?showto...#entry365 442 or http://www.gmayor.com/downloads.htm#Third_party -- Cheers macropod [MVP - Microsoft Word] "dbalorenzini" wrote in message ... I am working with a table in Microsoft Word 2007. I have figured out how to add up a certain number of cells and do a sum and have that formatted for currency. My question is that the cells that are in the formula (B1+B2+B3, etc.) do not appear as currency. How can I format the entry cells for currency? Thank you for you advice in advance. |
#3
![]()
Posted to microsoft.public.word.tables
|
|||
|
|||
![]()
Thank you for your reply. That works for my SUM cells but I am talking about
the cells that are being sum. eg. =SUM(B1+B2+B3) I am talking about setting the cell format to currency in the cells that the numbers are being entered, in this case B1, B2, and B3. -- Thanks, Art Database Administrator Yankton, SD "macropod" wrote: Hi dbalorenzini, You can do this by adding a numeric picture switch to the SUM field. To do this: .. select the field; .. press Shift-F9 to reveal the field coding. It should look something like {=SUM(B1:B3)} (note that you don't need to specify each cell in a spanned range); .. edit the field so that you get {=SUM(B1:B3) \# $,0.00} (or whatever other numeric format you prefer - see below); .. position the cursor anywhere in this field and press F9 to update it; .. run your mailmerge. Note: The '\# 0' in the field is referred to as a numeric picture switch. Other possibilities include: .. \# 0 for rounded whole numbers .. \# ,0 for rounded whole numbers with a thousands separator .. \# ,0.00 for numbers accurate to two decimal places, with a thousands separator .. \# $,0 for rounded whole dollars with a thousands separator .. \# $,0.00;($,0.00);- for currency, with brackets around negative numbers and a hyphen for 0 values The precision of the displayed value is controilled by the '0.00'. You can use anything from '0' to '0.000000000000000'. If you use a final ';' in the formatting switch with nothing following, (eg \# $,0.00;($,0.00) ![]() Note that this suppresses 0s resulting from empty fields and from fields containing 0s. For more information on doing calculations in Word, check out my Word Field Maths Tutorial, at: http://www.wopr.com/index.php?showto...#entry365 442 or http://www.gmayor.com/downloads.htm#Third_party -- Cheers macropod [MVP - Microsoft Word] "dbalorenzini" wrote in message ... I am working with a table in Microsoft Word 2007. I have figured out how to add up a certain number of cells and do a sum and have that formatted for currency. My question is that the cells that are in the formula (B1+B2+B3, etc.) do not appear as currency. How can I format the entry cells for currency? Thank you for you advice in advance. |
#4
![]()
Posted to microsoft.public.word.tables
|
|||
|
|||
![]()
Insert an Excel spreadsheet instead of a Word table.
-- 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 "alorenzini" wrote in message ... Thank you for your reply. That works for my SUM cells but I am talking about the cells that are being sum. eg. =SUM(B1+B2+B3) I am talking about setting the cell format to currency in the cells that the numbers are being entered, in this case B1, B2, and B3. -- Thanks, Art Database Administrator Yankton, SD "macropod" wrote: Hi dbalorenzini, You can do this by adding a numeric picture switch to the SUM field. To do this: .. select the field; .. press Shift-F9 to reveal the field coding. It should look something like {=SUM(B1:B3)} (note that you don't need to specify each cell in a spanned range); .. edit the field so that you get {=SUM(B1:B3) \# $,0.00} (or whatever other numeric format you prefer - see below); .. position the cursor anywhere in this field and press F9 to update it; .. run your mailmerge. Note: The '\# 0' in the field is referred to as a numeric picture switch. Other possibilities include: .. \# 0 for rounded whole numbers .. \# ,0 for rounded whole numbers with a thousands separator .. \# ,0.00 for numbers accurate to two decimal places, with a thousands separator .. \# $,0 for rounded whole dollars with a thousands separator .. \# $,0.00;($,0.00);- for currency, with brackets around negative numbers and a hyphen for 0 values The precision of the displayed value is controilled by the '0.00'. You can use anything from '0' to '0.000000000000000'. If you use a final ';' in the formatting switch with nothing following, (eg \# $,0.00;($,0.00) ![]() Note that this suppresses 0s resulting from empty fields and from fields containing 0s. For more information on doing calculations in Word, check out my Word Field Maths Tutorial, at: http://www.wopr.com/index.php?showto...#entry365 442 or http://www.gmayor.com/downloads.htm#Third_party -- Cheers macropod [MVP - Microsoft Word] "dbalorenzini" wrote in message ... I am working with a table in Microsoft Word 2007. I have figured out how to add up a certain number of cells and do a sum and have that formatted for currency. My question is that the cells that are in the formula (B1+B2+B3, etc.) do not appear as currency. How can I format the entry cells for currency? Thank you for you advice in advance. |
#5
![]()
Posted to microsoft.public.word.tables
|
|||
|
|||
![]()
Hi alorenzini,
Unless you're using a formula field, text formfield or a userform to populate the cell, Word has no auto-format tools to do the formatting for you. -- Cheers macropod [MVP - Microsoft Word] "alorenzini" wrote in message ... Thank you for your reply. That works for my SUM cells but I am talking about the cells that are being sum. eg. =SUM(B1+B2+B3) I am talking about setting the cell format to currency in the cells that the numbers are being entered, in this case B1, B2, and B3. -- Thanks, Art Database Administrator Yankton, SD "macropod" wrote: Hi dbalorenzini, You can do this by adding a numeric picture switch to the SUM field. To do this: .. select the field; .. press Shift-F9 to reveal the field coding. It should look something like {=SUM(B1:B3)} (note that you don't need to specify each cell in a spanned range); .. edit the field so that you get {=SUM(B1:B3) \# $,0.00} (or whatever other numeric format you prefer - see below); .. position the cursor anywhere in this field and press F9 to update it; .. run your mailmerge. Note: The '\# 0' in the field is referred to as a numeric picture switch. Other possibilities include: .. \# 0 for rounded whole numbers .. \# ,0 for rounded whole numbers with a thousands separator .. \# ,0.00 for numbers accurate to two decimal places, with a thousands separator .. \# $,0 for rounded whole dollars with a thousands separator .. \# $,0.00;($,0.00);- for currency, with brackets around negative numbers and a hyphen for 0 values The precision of the displayed value is controilled by the '0.00'. You can use anything from '0' to '0.000000000000000'. If you use a final ';' in the formatting switch with nothing following, (eg \# $,0.00;($,0.00) ![]() Note that this suppresses 0s resulting from empty fields and from fields containing 0s. For more information on doing calculations in Word, check out my Word Field Maths Tutorial, at: http://www.wopr.com/index.php?showto...#entry365 442 or http://www.gmayor.com/downloads.htm#Third_party -- Cheers macropod [MVP - Microsoft Word] "dbalorenzini" wrote in message ... I am working with a table in Microsoft Word 2007. I have figured out how to add up a certain number of cells and do a sum and have that formatted for currency. My question is that the cells that are in the formula (B1+B2+B3, etc.) do not appear as currency. How can I format the entry cells for currency? Thank you for you advice in advance. |
#6
![]()
Posted to microsoft.public.word.tables
|
|||
|
|||
![]()
OK thanks for the update. It looks like it back to the drawing board.
-- Thanks, Art Database Administrator Yankton, SD "macropod" wrote: Hi alorenzini, Unless you're using a formula field, text formfield or a userform to populate the cell, Word has no auto-format tools to do the formatting for you. -- Cheers macropod [MVP - Microsoft Word] "alorenzini" wrote in message ... Thank you for your reply. That works for my SUM cells but I am talking about the cells that are being sum. eg. =SUM(B1+B2+B3) I am talking about setting the cell format to currency in the cells that the numbers are being entered, in this case B1, B2, and B3. -- Thanks, Art Database Administrator Yankton, SD "macropod" wrote: Hi dbalorenzini, You can do this by adding a numeric picture switch to the SUM field. To do this: .. select the field; .. press Shift-F9 to reveal the field coding. It should look something like {=SUM(B1:B3)} (note that you don't need to specify each cell in a spanned range); .. edit the field so that you get {=SUM(B1:B3) \# $,0.00} (or whatever other numeric format you prefer - see below); .. position the cursor anywhere in this field and press F9 to update it; .. run your mailmerge. Note: The '\# 0' in the field is referred to as a numeric picture switch. Other possibilities include: .. \# 0 for rounded whole numbers .. \# ,0 for rounded whole numbers with a thousands separator .. \# ,0.00 for numbers accurate to two decimal places, with a thousands separator .. \# $,0 for rounded whole dollars with a thousands separator .. \# $,0.00;($,0.00);- for currency, with brackets around negative numbers and a hyphen for 0 values The precision of the displayed value is controilled by the '0.00'. You can use anything from '0' to '0.000000000000000'. If you use a final ';' in the formatting switch with nothing following, (eg \# $,0.00;($,0.00) ![]() Note that this suppresses 0s resulting from empty fields and from fields containing 0s. For more information on doing calculations in Word, check out my Word Field Maths Tutorial, at: http://www.wopr.com/index.php?showto...#entry365 442 or http://www.gmayor.com/downloads.htm#Third_party -- Cheers macropod [MVP - Microsoft Word] "dbalorenzini" wrote in message ... I am working with a table in Microsoft Word 2007. I have figured out how to add up a certain number of cells and do a sum and have that formatted for currency. My question is that the cells that are in the formula (B1+B2+B3, etc.) do not appear as currency. How can I format the entry cells for currency? Thank you for you advice in advance. |
Reply |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
formatting cell for currency in word table | Tables | |||
How do I format Mail Merge doc to pick up currency format from Exc | Mailmerge | |||
HOW DO I MAIL MERGE AN EXCEL CELL WITH CURRENCY FORMATING . | Mailmerge | |||
Currency format | Mailmerge | |||
Currency fields in Access lose th currency format whn merged why | Mailmerge |