View Single Post
  #2   Report Post  
Greg Maxey
 
Posts: n/a
Default

BCBC

You will need a numeric switch something like \# "$,0.00;(S,0.00);"
See:

http://www.gmayor.com/formatting_word_fields.htm
the section for suppressing zero dispaly
--
Greg Maxey/Word MVP
See:
http://gregmaxey.mvps.org/word_tips.htm
For some helpful tips using Word.

BCBC wrote:
I'm creating a travel expense form and want some boxes to be able to
auto-calculate. Sometimes it will be filled out in Word, and
sometimes as a regular paper form. When I enter the formula, a zero
appears if there is nothing in the cells that the formula references.
This will make the printed version less attractive. Can I get rid of
the zeros?