Reply
 
Thread Tools Display Modes
  #1   Report Post  
BCBC
 
Posts: n/a
Default Getting rid of zeros in formulas

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



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Formulas in Word Tables Dave New Users 5 April 2nd 05 08:53 PM
How do I set up a formulas in Word Rado New Users 2 March 19th 05 04:11 PM
Word should auto update Formulas in the same way Excel does SmokeyMcPotHead Microsoft Word Help 3 February 26th 05 03:37 PM
How to write Scientific chemical formulas? Scott Microsoft Word Help 4 February 22nd 05 09:00 PM
Dissapearing zeros? Kalevi New Users 1 January 12th 05 03:35 PM


All times are GMT +1. The time now is 10:43 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"