Show 0 as Zero, Nil, Dashes or Hide Completely | Excel Tricks

In this Excel Quick Tip Tutorial we are learning how to display or show number 0 as a word Zero, Zilch, Nil, Nill, or dashes like - or --- and even how to hide the zeroes altogether from Excel workbook.
More tutorials on Excel Custom Number Formatting: pakaccountants...
FREE Excel Tutorials and Resources: pakaccountants...
Fb: / learnexceltoexcel
Tw: / exceltoexcel
Pin: / pakaccountants
#LearnExcel #ExcelTips #ExcelTricks

[@HasaanFazal]

How do you like to format zeroes in Excel?

[@jimguertin8769]

How do you change cells that have 0s or any 1 particular number to a truely blank cell (i.e. no ' in the cell) without doing it manually cell by cell

[@HasaanFazal]

Great idea for another tutorial. Working on it straight away

[@timryan8867]

I am using a laptop and can't fully see all of what you are typing before the words in the "type" section when formatting the cell.

[@HasaanFazal]

0;0;"Zero"

[@spreadknowledgeknowledge3361]

@@HasaanFazal Thankyou for writing this custom format.

[@HasaanFazal]

@@spreadknowledgeknowledge3361 glad it helped

[@hamaadfazal]

Thanks for sharing. Keep them coming

[@mandyj6387]

On the flip side of this: how would one make an accounting-formatted column display a nil value as $0.00?

[@HasaanFazal]

You mean an empty cell to show $0.00?

[@papiadey2241]

U r very bogus...not at all working