Default Values for Custom Numbers

[kenf]

I am trying to use the CostX and NumberX columns to enter data relevant to my
project. I would like the column to be blank until I enter data. The
default display for CostX is $0.00. In NumberX, I've entered a formula, I
want it to display the value if greater than 0. If the result of the formula
equals zero, I don't want the column to display a number (0).

Is there a way to set the default to not display a value in the column?

I want to do this in order for the entered data to stand out.

I'm using MS Project 2003 Professional.

 

[John]

I am trying to use the CostX and NumberX columns to enter data relevant to my
project. I would like the column to be blank until I enter data. The
default display for CostX is $0.00. In NumberX, I've entered a formula, I
want it to display the value if greater than 0. If the result of the formula
equals zero, I don't want the column to display a number (0).

Is there a way to set the default to not display a value in the column?

I want to do this in order for the entered data to stand out.

I'm using MS Project 2003 Professional.

kenf,
With regard to spare Cost fields the default value is $0.00 (or whatever
currency symbol is specified in Tools/Options/View tab) and cannot be
changed to have a blank value. Likewise for spare Number fields, the
default value is "0" and cannot be made blank.

If your goal is to have the information stand out there are basically
two options that come to mind. One is to use spare Text fields instead
of Cost and Number fields. Spare Text fields have a default of blank. Of
course currency values will need to be formatted but this can be easily
done by using the "CCur" conversion function. A second option for making
the values stand out is to highlight the text in a different color
although in order to do this either a manual setting or a simple VBA
routine will be necessary.

Hope this helps.
John
Project MVP