Display or hide zero values – Excel – Microsoft Office Online

Display or hide zero values – Excel – Microsoft Office Online
You may have a personal preference to display zero values in a cell, or you may be using a spreadsheet that adheres to a set of format standards that requires you to hide zero values. There are several ways to display or hide zero values.

Comments

2 Responses to “Display or hide zero values – Excel – Microsoft Office Online”

  1. Kath Avatar

    This link is for Office 2007. For earlier versions, go to Tools, Options and from the View tab look for the ‘zero values’ check box in the bottom section (window options).
    :o)

  2. scruss Avatar

    I found the 0;-0;;@ number format worked fine in Office 2003.

Leave a Reply

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