Is there a switch that will show no dollar sign if there's no data?

[Jim]

Hi,
I'm using Office 2000 Pro and have a mail merge doc.
using Word with Excel as the data source (which is a
template, i.e. I copy it and use it for many different
cases). Also, I merge the data from Excel to Word into
Word tables.
My question is this: Is there a switch that will show
nothing in the table cell when no data is being merged?
Sometimes a Word table will have all cells merged into
it, and sometimes it will not. However, I want to have a
switch with the $ sign in all of them since each case is
different and I never know which cell will have data and
which will not. Is there a switch that will show the
dollar sign, but also be able to not show it if no
numbers are merged to that particular cell? (I want to
avoid showing zeros or zeros with $ signs if I can).
I hope the question is clear enough, and thanks (as
always) for the great help.

 

[Graham Mayor]

See the section on suppressing zeros at
http://www.gmayor.com/formatting_word_fields.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Jim]

Thanks so much for the website and help. What I'm having
problems with is suppressing the dollar sign in a cell
when no data is merged into it. Because, it appears that
if no data is merged to the cell, the switch will cause
there to be a dollar sign with no number following it.
Can there be a switch that would suppress the dollar sign
if nothing is merged to that cell?

Thanks again, Jim

 

[Graham Mayor]

In that case it needs a slight modification:

{IF {Mergefield fieldname} <> "" "{Mergefield fieldname \# ",$0.00"}" }

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[macropod]

Or, more simply:
{Mergefield fieldname \# $,0.00;-$,0.00;}
The \# $,0.00;-$0,.00; tells Word how to treat positive ($,0.00), negative
(-$,0.00) and zero () values. In this case nothing displays for zero values
because there is nothing after the second semi-colon. Note the correct
placement of the commas.

Cheers

 

[Graham Mayor]

My web page demonstrates that method, but the OP responded that it wasn't
working. The additional response was more brute force

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Jim]

That worked really well, you've really helped me out
quite a bit.

 

[Jim]

I really appreciate the inpu; your advice worked really
well and you've helped me tremendously, thanks again.