Supress zeros in printout

A

ashokdad

How do I supress the zeros printed out and displayed in the custom cost or
number fields. I want to list projected value numbers for key tasks, and I
don't want to display/print a bunch of zeros for the other tasks in the
project--suggesting that they have no value
 
R

Rod Gill

Another option is to put a formula in a Text field that uses an IF statement
that doesn't display anything if the test returns zero

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com




Trevor Rabey said:
Crude but effective:
Select them and then Format, Font - white.
--
Trevor Rabey
0407213955
61 8 92727485
PERFECT PROJECT PLANNING
www.perfectproject.com.au





__________ Information from ESET Smart Security, version of virus
signature database 4620 (20091118) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4620 (20091118) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top