Microsoft Office Tutorials and References
In Depth Information
Displaying a negative sign on the right
Displaying a negative sign on the right
The following format string displays negative values with the negative sign to the right of the
number. Positive values have an additional space on the right, so both positive and negative
numbers align properly on the right:
0.00_-;0.00-
Suppressing certain types of entries
You can use number formatting to hide certain types of entries. For example, the following
format string displays text but not values:
;;
This format string displays values (with one decimal place) but not text or zeros:
0.0;-0.0;;
This format string displays everything except zeros (values are displayed with one decimal
place):
0.0;-0.0;;@
You can use the following format string to completely hide the contents of a cell:
;;;
Note that when the cell is activated, however, the cell’s contents are visible on the Formula bar.
 
Search JabSto ::




Custom Search