There are Excel built-in options to set how zeros are displayed in the spread sheet. However, there are times when only certain cells need the special exceptional treatment then a little more work is involved with customer cell formatting.
This is written in the context of an Visual Studio 2010 and VSTO Excel add-in, that I created and had to deploy using the setup project after exploring all other options including ClickOnce, Wix, InstallShield and what-not. As it turns out, the Visual Studio Setup Project remains to be the easiest to understand and use. […]