lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
I formatted a cell using custom format and type code # so I typed 100 and got 100, typed -100 and got -100, typed 0, and got empty cell, typed Hello, and got Hello.
I understand why 100, and -100 but what I do not get why 0 got hidden and why Hello is showing.
I know it is
Positive, Negative, Zero, Text
So when I have code #, I expect excel to show 0 but not Hello,
So why I have a code #, does that mean it is appled to positive and negative and text but not zero?
Thank you.
I formatted a cell using custom format and type code # so I typed 100 and got 100, typed -100 and got -100, typed 0, and got empty cell, typed Hello, and got Hello.
I understand why 100, and -100 but what I do not get why 0 got hidden and why Hello is showing.
I know it is
Positive, Negative, Zero, Text
So when I have code #, I expect excel to show 0 but not Hello,
So why I have a code #, does that mean it is appled to positive and negative and text but not zero?
Thank you.