Cell Formats, Displaying Only Positive Numbers

[amarshall]

I have two workbooks that are hard linked to each other. Can I format the sheet so that the only values shown are greater than 0.

One sheet has data

The second sheet has a nice display of this data in categories.
I want the second sheet to only display positive values.

 

[TommyGun]

You can apply a custom number format to the cells, leaving the Negative and Zero value formats blank...

#,##0;;

 

[Greg Truby]

Use a custom number format along the lines of:

#,##0;;

or

0;;

or

#,##0.00;;

The first argument (args separated by semicolons) is for positives; 2nd is for negatives, third is for zeroes. If you omit 2nd and 3rd arguments, then nothing is displayed for negatives or zeroes. [Edit] Tommy was too quick for me! [EndEdit]

 

[amarshall]

you guys are awesome ray: