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

From: Graham Mayor (gmayor_at_DELETECAPSmvps.org)
Date: 08/30/04 

Date: Mon, 30 Aug 2004 16:34:20 +0100

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

-- 
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor -  Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Jim wrote:
> 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.

Relevant Pages

  • Re: Macros to add a row in a word table
    ... Graham Mayor - Word MVP ... Word MVP web site http://word.mvps.org ... from the cell in which the Word formula field is placed. ...
    (microsoft.public.word.vba.general)
  • Re: Macros to add a row in a word table
    ... Graham Mayor - Word MVP ... Word MVP web site http://word.mvps.org ... from the cell in which the Word formula field is placed. ...
    (microsoft.public.word.vba.general)
  • Re: 4 word forms on 1 paper page.
    ... document into a fixed width table cell, but this is altogether more fiddly ... Word MVP web site http://word.mvps.org ... Thanks for your help, Brian. ...
    (microsoft.public.word.newusers)
  • Re: Showing todays date when the Excel value is zero
    ... Word MVP web site http://word.mvps.org ... > When I remove the date formatting from the Excel cell then the Word ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Time calculations
    ... Word MVP web site http://word.mvps.org ... Each following cell the four columns is formatted for time. ... software needs the time worked in decimal format ...
    (microsoft.public.excel.newusers)
Quantcast