There seems to be something wrong with a certain custom number format. This is the custom entry I made:
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.

Attached Files

Sample.xlsx (8.8 KB, 3 views)