Thanks but that doesn't seem to work. The cells are showing as % already. I
want the cells that are showing 0% to appear empty, even though some of these
cells actually contain a number < 0. I can hide the genuine zero values
using conditional formatting.


"topola" wrote:

Select Entire Table
Select Data
CTRL + 1 (Format Cells)
Custom Type: (type the following:) 0%;-0%;-

6/1939 = 0.3% looks like 0% will be left on screen. Real zeros will be
shown as "-".

Tomek Polak, http://vba.blog.onet.pl