Have table formatted as currency and want all cells to show $0.00 when the formula value is ""

LabrGuy Bob R · Nov 18, 2007

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

macropod · Nov 18, 2007

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

LabrGuy Bob R · Nov 18, 2007

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

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

Click to expand...

LabrGuy Bob R · Nov 18, 2007

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

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

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

Click to expand...

Click to expand...

macropod · Nov 18, 2007

Hi Bob,

Try embedding your mergefield in formula field coded as::
{=«YECMP» \# $,0.00}

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

LabrGuy Bob R said:
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 said:

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

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

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

Click to expand...

Click to expand...