There seems to be something wrong with a certain custom number format. This is the custom entry I made:
Code:
General;-General;"";@
It should display any number as I entered it except for 0.
As you can see in column A of my worksheet, when I enter a number with this format the number is treated as text, not a number.
Bug 2: In column B, I entered 0's and converted them to values, but the 0's display even though the format is supposed to suppress them.
What gives? I want a custom format where numbers are displayed as General but not zeros.