Tom’s Tutorials For Excel: Formatting 0 to Look Like “Zero”

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.

Share Button
Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , , ,
9 comments on “Tom’s Tutorials For Excel: Formatting 0 to Look Like “Zero”
  1. chakravarthy says:

    these tips are very useful

  2. Fernando says:

    Its an amazing tips… You are a Excel jedi

  3. Krishnamurthy says:

    Thanks useful tip

  4. Mukesh Katara says:

    Nice trick

  5. sandeep kothari says:

    Fabulous!

Leave a Reply

Your email address will not be published. Required fields are marked *

*