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.
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)
I found the 0;-0;;@ number format worked fine in Office 2003.