excel number format hide values cheat sheet
EXCEL NUMBER FORMAT HIDE VALUES CHEAT SHEET
If any section of a Number Format is left blank, the value of
that section is hidden.
Sections should always be separated (defined) by a semicolon (;).
Here are some examples:
Value Format Formatted
---------------------------------------------------------------------
1 0;;0; 1
-2 0;;0;
0 0;;0; 0
Some text 0;;0;
1 ;(0);;@
-2 ;(0);;@ (2)
0 ;(0);;@
Some text ;(0);;@ Some Text
1 ;;;
-2 ;;;
0 ;;;
Some text ;;;