Using custom number prevent zero and negative values being displayed

[reddwarf4ever]

Using custom number prevent zero and negative values being displayed.

I have a simple worksheet, which I want to hide negative and zero results.....

I found this for hiding zero value cells only ........0;-0;;@

Is there a simple way of working out myself how to hide or change various aspects of cells....colour etc and also how to group actions.

Thanks

 

[AIM]

Hi,

Apply this custom format in the column where you have numbers #,###;

Regards!!

 

[Debraj]

There are 4 part in Custom Number Formatting..

Positive ; Negative ; Zero ; Text

You can hide any of this... in you case.. use formatting as
#;;;@

which is.. hiding below two parts..
Positive ; Negative ; Zero ; Text

 

[oldchippy]

@reddwarf4ever

Here are some more custom formats here you may find useful

http://chandoo.org/wp/2008/02/25/custom-cell-formatting-in-excel-few-tips-tricks/

 

[reddwarf4ever]

There are 4 part in Custom Number Formatting..

Positive ; Negative ; Zero ; Text

You can hide any of this... in you case.. use formatting as
#;;;@

which is.. hiding below two parts..
Positive ; Negative ; Zero ; Text

Hi
Thanks, that looks interesting.....i assume then that the ; acts as a block for each field....the # and @ are just open and close symbols.....or I could be wrong LOL

Is there a way of including this but also hiding error values also, or could this be handled differently ?

I tried iferror, but had some strange results....also want the cells to have % value, .dont know if this can be added to #;;;@ or not

Thanks

Ps will look at link supplied by old chippy.....

 

[Debraj]

# is for.. Any Number..
so for example Number Format is 00.00%;;
if you use 00.00% it will display 2 digit after and before Decimal and a %age sign.
If you write 9 it will display as 09.00% and because you are forcing it to show 2 digit before decimal.
and if you write 112, it will display as 112.00% as excel forcing it to show complete value.
# is not outer format.. just the way you have entered thenumber..

try custom number format 0.00%; ;

 

[oldchippy]

If the numbers you want to hide are the results of formulas, then you could use something like this to hide zero's, minus numbers and errors

=IFERROR(IF(A1<=0,"",A1),"")