Supress zeros in printout
in [Project]
|
From: ashokdad on 18 Nov 2009 15:15 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
From: Trevor Rabey on 18 Nov 2009 19:33 Crude but effective: Select them and then Format, Font - white. -- Trevor Rabey 0407213955 61 8 92727485 PERFECT PROJECT PLANNING www.perfectproject.com.au "ashokdad" <ashokdad(a)discussions.microsoft.com> wrote in message news:E7EEFA57-5A62-47A3-B814-9CD94983160B(a)microsoft.com... > 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
From: Rod Gill on 18 Nov 2009 20:26 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" <trevorATperfectproject.com.au> wrote in message news:xqKdnQX08vF6D5nWnZ2dnUVZ7tWdnZ2d(a)westnet.com.au... > Crude but effective: > Select them and then Format, Font - white. > -- > Trevor Rabey > 0407213955 > 61 8 92727485 > PERFECT PROJECT PLANNING > www.perfectproject.com.au > > "ashokdad" <ashokdad(a)discussions.microsoft.com> wrote in message > news:E7EEFA57-5A62-47A3-B814-9CD94983160B(a)microsoft.com... >> 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 > > > > __________ 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
|
Pages: 1 Prev: When I enter an Actual Work value, Work value alters. Why? Next: How to use Autocorrect? |