excel number format hide values cheat sheet code example

Example: 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   ;;;