lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
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.
<tbody>
</tbody>
Thank you very much
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.
Test |
100 |
-44 |
0 |
Hello |
<tbody>
</tbody>
Thank you very much