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