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