| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Have table formatted as currency and want all cells to show $0.00 when the formula value is ""
Hello, I have WORD 2003 and Win XPPro. I have a table, as show below that
shows Assessed values of a fine -- Reduction amount of the fine -- and the total due of the fine. It is a mail merge document that draws information from an Excel spreadsheet/database. All of the cells appear to be formatted the same way and the formulas are all calculated the same. I need to show $0.00 all the time in the table boxes as indicated in the tables below. I actually need to display and print $0.00 in the Assessed column for three, the Reductions column 4th total cell and in the Total Due the Total due. Or if I can't get that settled then I would like to have all blanks in each, and when merged show the actual dollar value with the blanks as blank. Whichever.. I've tried everything that I can figure out with no luck. Any help would be greatly appreciated Thanks BOB Assessed Reduction Total Due «YECMP» «YECMPREDUCTAMT» «YECCMPTOTDUE» «RKCMP» «RKCMPREDUCAMOUNT» «RKCMPTOTDUE» «CSERACMP» «CSERAREDUCTAMT» «CSERACMPTOTDUE» «TOTALCMPSASSESD» «TOTALCMPRED» «TOTALCMPDUE» Assessed Reduction Total Due $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 |
|
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Have table formatted as currency and want all cells to show $0.00 when the formula value is ""
Hi Bob,
It's not exactly clear what you're trying to do. So you've apparently got some headers: 'Assessed' 'Reduction' 'Total Due' and a bunch of mailmerge fields: «YECMP» «YECMPREDUCTAMT» «YECCMPTOTDUE» «RKCMP» «RKCMPREDUCAMOUNT» «RKCMPTOTDUE» «CSERACMP» «CSERAREDUCTAMT» «CSERACMPTOTDUE» «TOTALCMPSASSESD» «TOTALCMPRED» «TOTALCMPDUE» I don't see any formulae that might relate these to each other in any way. You also say "I need to show $0.00 all the time in the table boxes as indicated". I don't see a table - all I see is a single column with the above mergefields/strings followed by a repeat of what appears to be the header strings followed by some $0.00s. By "I need to show $0.00", do you mean you need the mailmerge results to show as currency? If so, select the mailmerge fields that need to be displayed this way, press Shift-F9 to expose the field code (eg «YECMP» becomed {YECMP}), then add a currency picture switch to the field, thus {YECMP \# $,0.00}. See Word's help file for more information on field formatting. This newsgroup is also replete with questions and answers about mergefield formatting. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "LabrGuy Bob R" wrote in message ... Hello, I have WORD 2003 and Win XPPro. I have a table, as show below that shows Assessed values of a fine -- Reduction amount of the fine -- and the total due of the fine. It is a mail merge document that draws information from an Excel spreadsheet/database. All of the cells appear to be formatted the same way and the formulas are all calculated the same. I need to show $0.00 all the time in the table boxes as indicated in the tables below. I actually need to display and print $0.00 in the Assessed column for three, the Reductions column 4th total cell and in the Total Due the Total due. Or if I can't get that settled then I would like to have all blanks in each, and when merged show the actual dollar value with the blanks as blank. Whichever.. I've tried everything that I can figure out with no luck. Any help would be greatly appreciated Thanks BOB Assessed Reduction Total Due «YECMP» «YECMPREDUCTAMT» «YECCMPTOTDUE» «RKCMP» «RKCMPREDUCAMOUNT» «RKCMPTOTDUE» «CSERACMP» «CSERAREDUCTAMT» «CSERACMPTOTDUE» «TOTALCMPSASSESD» «TOTALCMPRED» «TOTALCMPDUE» Assessed Reduction Total Due $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 |
|
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Have table formatted as currency and want all cells to show $0.00 when the formula value is ""
Thanks for the response. I've searched all over and am a little familiar
with switches etc. I can't find an answer for this problem. As you can see each table cell that contains merge data is underlined.All are formatted with the switch that you provided, and that is like the {CSERACMP \# $,0.00} below. The underlined areas are each a cell, couldn't get the gridlines to print out, and where you see no $0.00 is formatted exactly the same as the ones with $0.00. My delima is I can't get all of them the same..... either without the $0.00 at all or show all with the $0.00. My apologies for not being clear before but I'm kinda at my wits end with this one. Thanks in advance. Bob Youth Employment Violation(s): $0.00 $0.00 Recordkeeping Violation(s): $0.00 $0.00 CSERA Violation(s): {CSERACMP \# $,0.00} $0.00 $0.00 Total: $0.00 "macropod" wrote in message ... Hi Bob, It's not exactly clear what you're trying to do. So you've apparently got some headers: 'Assessed' 'Reduction' 'Total Due' and a bunch of mailmerge fields: «YECMP» «YECMPREDUCTAMT» «YECCMPTOTDUE» «RKCMP» «RKCMPREDUCAMOUNT» «RKCMPTOTDUE» «CSERACMP» «CSERAREDUCTAMT» «CSERACMPTOTDUE» «TOTALCMPSASSESD» «TOTALCMPRED» «TOTALCMPDUE» I don't see any formulae that might relate these to each other in any way. You also say "I need to show $0.00 all the time in the table boxes as indicated". I don't see a table - all I see is a single column with the above mergefields/strings followed by a repeat of what appears to be the header strings followed by some $0.00s. By "I need to show $0.00", do you mean you need the mailmerge results to show as currency? If so, select the mailmerge fields that need to be displayed this way, press Shift-F9 to expose the field code (eg «YECMP» becomed {YECMP}), then add a currency picture switch to the field, thus {YECMP \# $,0.00}. See Word's help file for more information on field formatting. This newsgroup is also replete with questions and answers about mergefield formatting. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "LabrGuy Bob R" wrote in message ... Hello, I have WORD 2003 and Win XPPro. I have a table, as show below that shows Assessed values of a fine -- Reduction amount of the fine -- and the total due of the fine. It is a mail merge document that draws information from an Excel spreadsheet/database. All of the cells appear to be formatted the same way and the formulas are all calculated the same. I need to show $0.00 all the time in the table boxes as indicated in the tables below. I actually need to display and print $0.00 in the Assessed column for three, the Reductions column 4th total cell and in the Total Due the Total due. Or if I can't get that settled then I would like to have all blanks in each, and when merged show the actual dollar value with the blanks as blank. Whichever.. I've tried everything that I can figure out with no luck. Any help would be greatly appreciated Thanks BOB Assessed Reduction Total Due «YECMP» «YECMPREDUCTAMT» «YECCMPTOTDUE» «RKCMP» «RKCMPREDUCAMOUNT» «RKCMPTOTDUE» «CSERACMP» «CSERAREDUCTAMT» «CSERACMPTOTDUE» «TOTALCMPSASSESD» «TOTALCMPRED» «TOTALCMPDUE» Assessed Reduction Total Due $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 |
|
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Have table formatted as currency and want all cells to show $0.00 when the formula value is ""
I did some more checking and found the original Excel database from where
these are imported to have the $0.00, but only in some of the cells. So my question changes to one of would this statement work for all the cells??? IF { Mergefield "YECMP" } = "$0.00" "" "{ Mergefield "YECMP" } I think this will check and see if the value is $0.00 and return a blank and if not blank return the value.? Am I close. Thanks BOB "LabrGuy Bob R" wrote in message ... Thanks for the response. I've searched all over and am a little familiar with switches etc. I can't find an answer for this problem. As you can see each table cell that contains merge data is underlined.All are formatted with the switch that you provided, and that is like the {CSERACMP \# $,0.00} below. The underlined areas are each a cell, couldn't get the gridlines to print out, and where you see no $0.00 is formatted exactly the same as the ones with $0.00. My delima is I can't get all of them the same..... either without the $0.00 at all or show all with the $0.00. My apologies for not being clear before but I'm kinda at my wits end with this one. Thanks in advance. Bob Youth Employment Violation(s): $0.00 $0.00 Recordkeeping Violation(s): $0.00 $0.00 CSERA Violation(s): {CSERACMP \# $,0.00} $0.00 $0.00 Total: $0.00 "macropod" wrote in message ... Hi Bob, It's not exactly clear what you're trying to do. So you've apparently got some headers: 'Assessed' 'Reduction' 'Total Due' and a bunch of mailmerge fields: «YECMP» «YECMPREDUCTAMT» «YECCMPTOTDUE» «RKCMP» «RKCMPREDUCAMOUNT» «RKCMPTOTDUE» «CSERACMP» «CSERAREDUCTAMT» «CSERACMPTOTDUE» «TOTALCMPSASSESD» «TOTALCMPRED» «TOTALCMPDUE» I don't see any formulae that might relate these to each other in any way. You also say "I need to show $0.00 all the time in the table boxes as indicated". I don't see a table - all I see is a single column with the above mergefields/strings followed by a repeat of what appears to be the header strings followed by some $0.00s. By "I need to show $0.00", do you mean you need the mailmerge results to show as currency? If so, select the mailmerge fields that need to be displayed this way, press Shift-F9 to expose the field code (eg «YECMP» becomed {YECMP}), then add a currency picture switch to the field, thus {YECMP \# $,0.00}. See Word's help file for more information on field formatting. This newsgroup is also replete with questions and answers about mergefield formatting. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "LabrGuy Bob R" wrote in message ... Hello, I have WORD 2003 and Win XPPro. I have a table, as show below that shows Assessed values of a fine -- Reduction amount of the fine -- and the total due of the fine. It is a mail merge document that draws information from an Excel spreadsheet/database. All of the cells appear to be formatted the same way and the formulas are all calculated the same. I need to show $0.00 all the time in the table boxes as indicated in the tables below. I actually need to display and print $0.00 in the Assessed column for three, the Reductions column 4th total cell and in the Total Due the Total due. Or if I can't get that settled then I would like to have all blanks in each, and when merged show the actual dollar value with the blanks as blank. Whichever.. I've tried everything that I can figure out with no luck. Any help would be greatly appreciated Thanks BOB Assessed Reduction Total Due «YECMP» «YECMPREDUCTAMT» «YECCMPTOTDUE» «RKCMP» «RKCMPREDUCAMOUNT» «RKCMPTOTDUE» «CSERACMP» «CSERAREDUCTAMT» «CSERACMPTOTDUE» «TOTALCMPSASSESD» «TOTALCMPRED» «TOTALCMPDUE» Assessed Reduction Total Due $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 |
|
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Have table formatted as currency and want all cells to show $0.00 when the formula value is ""
Hi Bob,
Try embedding your mergefield in formula field coded as:: {=«YECMP» \# $,0.00} Cheers -- macropod [MVP - Microsoft Word] ------------------------- "LabrGuy Bob R" wrote in message ... I did some more checking and found the original Excel database from where these are imported to have the $0.00, but only in some of the cells. So my question changes to one of would this statement work for all the cells??? IF { Mergefield "YECMP" } = "$0.00" "" "{ Mergefield "YECMP" } I think this will check and see if the value is $0.00 and return a blank and if not blank return the value.? Am I close. Thanks BOB "LabrGuy Bob R" wrote in message ... Thanks for the response. I've searched all over and am a little familiar with switches etc. I can't find an answer for this problem. As you can see each table cell that contains merge data is underlined.All are formatted with the switch that you provided, and that is like the {CSERACMP \# $,0.00} below. The underlined areas are each a cell, couldn't get the gridlines to print out, and where you see no $0.00 is formatted exactly the same as the ones with $0.00. My delima is I can't get all of them the same..... either without the $0.00 at all or show all with the $0.00. My apologies for not being clear before but I'm kinda at my wits end with this one. Thanks in advance. Bob Youth Employment Violation(s): $0.00 $0.00 Recordkeeping Violation(s): $0.00 $0.00 CSERA Violation(s): {CSERACMP \# $,0.00} $0.00 $0.00 Total: $0.00 "macropod" wrote in message ... Hi Bob, It's not exactly clear what you're trying to do. So you've apparently got some headers: 'Assessed' 'Reduction' 'Total Due' and a bunch of mailmerge fields: «YECMP» «YECMPREDUCTAMT» «YECCMPTOTDUE» «RKCMP» «RKCMPREDUCAMOUNT» «RKCMPTOTDUE» «CSERACMP» «CSERAREDUCTAMT» «CSERACMPTOTDUE» «TOTALCMPSASSESD» «TOTALCMPRED» «TOTALCMPDUE» I don't see any formulae that might relate these to each other in any way. You also say "I need to show $0.00 all the time in the table boxes as indicated". I don't see a table - all I see is a single column with the above mergefields/strings followed by a repeat of what appears to be the header strings followed by some $0.00s. By "I need to show $0.00", do you mean you need the mailmerge results to show as currency? If so, select the mailmerge fields that need to be displayed this way, press Shift-F9 to expose the field code (eg «YECMP» becomed {YECMP}), then add a currency picture switch to the field, thus {YECMP \# $,0.00}. See Word's help file for more information on field formatting. This newsgroup is also replete with questions and answers about mergefield formatting. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "LabrGuy Bob R" wrote in message ... Hello, I have WORD 2003 and Win XPPro. I have a table, as show below that shows Assessed values of a fine -- Reduction amount of the fine -- and the total due of the fine. It is a mail merge document that draws information from an Excel spreadsheet/database. All of the cells appear to be formatted the same way and the formulas are all calculated the same. I need to show $0.00 all the time in the table boxes as indicated in the tables below. I actually need to display and print $0.00 in the Assessed column for three, the Reductions column 4th total cell and in the Total Due the Total due. Or if I can't get that settled then I would like to have all blanks in each, and when merged show the actual dollar value with the blanks as blank. Whichever.. I've tried everything that I can figure out with no luck. Any help would be greatly appreciated Thanks BOB Assessed Reduction Total Due «YECMP» «YECMPREDUCTAMT» «YECCMPTOTDUE» «RKCMP» «RKCMPREDUCAMOUNT» «RKCMPTOTDUE» «CSERACMP» «CSERAREDUCTAMT» «CSERACMPTOTDUE» «TOTALCMPSASSESD» «TOTALCMPRED» «TOTALCMPDUE» Assessed Reduction Total Due $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Tracked "Formatted Bullets and Numbering" | Microsoft Word Help | |||
| how do I set up a "expand/collapse" or "show/hide" field in Word | Microsoft Word Help | |||
| Search and replace blank cells with "N/A" within a Word Table | Tables | |||
| Table Formula "Bug" | Tables | |||
| disable "first letter of table cells" in "AutoCorrect" with regist | Microsoft Word Help | |||
Linear Mode
