hiding only +ve numbers

[lezawang]

Hi
I have the data below and I want to hide only positive numbers. So I went to Format Cells --> custom and typed ;

I thought that would ignored the +ve only since I did not write anything for the positive. I know
custom format is like this

positive; negative; 0; text

so ignoring positive simply not type anything, but when I typed only ; I lost all numbers (positive or negative) and 0 as well. Only text left.

[TABLE="class: grid, width: 300"]
<tbody>[TR]
[TD]Test[/TD]
[/TR]
[TR]
[TD]100[/TD]
[/TR]
[TR]
[TD]-44[/TD]
[/TR]
[TR]
[TD]0
[/TD]
[/TR]
[TR]
[TD]Hello[/TD]
[/TR]
</tbody>[/TABLE]

Thank you very much

 

[Joe4]

I would handle this a different way, with Conditional Formatting.
Use a Conditional Formatting formula like this:

=AND(ISNUMBER(A1),A1>0)

and choose the white font color option (which blends in with the background, making it invisible).

 

[joeu2004]

As you say, one Custom format is of the form postive;negative;zero.

So perhaps you want: ;-General;General

Change "General" to any specific format that you want. And omit the last ";General" if you want to hide zero, as well.