MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Is there a way to show zero values in only part of a spreadsheet?

Posted by Dwight on May 15, 2001 1:25 PM

I want to have zero values display in only one column of my spreadsheet. Any way to accomplish this ("Tools, Options, View, Zero Values" seems to be an all or nothing proposition).

Posted by lenze on May 15, 2001 1:47 PM


Set your options to hide zero values on the Tool <Options menu. Now Select the cells you wish to display zeros in and choose Format<Cells. On the number tab select Custom for the category and enter this in the type box.


This will diplay positive and negative numbers to 2 decimals and zeros as 0.

Posted by Mark W. on May 15, 2001 1:48 PM

Use cell formatting... 0;-0; to hide zeroes.

Posted by lenze on May 15, 2001 1:53 PM

First posting got garbled