Tom’s Tutorials For Excel: Formatting 0 to Look Like “Zero”
There are times when you want to see a number as text in order to visually set it apart from other numbers, while maintaining its value as a number. A custom format can accomplish this, because formatting a cell’s value only affects what you see, leaving the actual underlying value unaffected.
In this example, you want the numeral 0
to look like “zero”, as such:
• Select the range of interest. In the pictured example, that would be range B5:D16.
• From your keyboard, press Alt+O+E
to show the Format Cells dialog box.
• Click onto the Number tab.
• From the Category list, select Custom.
• In the Type field, enter the custom format [=0]"zero";General
• Click the OK button.
these tips are very useful
Thank you.
Its an amazing tips… You are a Excel jedi
Thank you, Fernando!
Thanks useful tip
Nice trick
Thank you, Mukesh.
Fabulous!
Thanks!