« l’air du bus
viva bus! »

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.

Tags: ,

This entry was posted on Wednesday, August 15th, 2007 at 18:03:19 and is filed under computers suck. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

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

  1. Kath Says:
    August 16th, 2007 at 09:34:44
    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 Says:
    August 17th, 2007 at 06:31:22
    I found the 0;-0;;@ number format worked fine in Office 2003.

Leave a Reply