If you want to display zero as blank in Excel, you will have to use this simple custom format for the cell:
0;-0;;@
But pay also attention to decimals if needed (point or comma for decimal separator, according to regional settings from control panel for windows):
0.00;-0.00;;@
There are many other ways to improve this custom format, just try in a new workbook to see how it works.
0;-0;;@
But pay also attention to decimals if needed (point or comma for decimal separator, according to regional settings from control panel for windows):
0.00;-0.00;;@
There are many other ways to improve this custom format, just try in a new workbook to see how it works.
No comments:
Post a Comment