Hide zero values in Listbox

[mucah!t]

Is there a way to hide zero values in a Listbox?

 

[mucah!t]

Anyone?

 

[Jaafar Tribak]

You can't AFAIK.

If the worksheet is fed from a range of cells then you could format the cells with the following Number Format :

0;0; ;

 

[Jaafar Tribak]

Sorry should be :

#;-#; ;@

For Intergers and text.

 

[mucah!t]

Awesome Jafaar!
Works like a charm