No need for VBA. You can make a custom number format for the labels.
Select the whole set of labels, press CTRL+1 to format, and on the
number format, select Custom in the left hand list, and add a format
like one of these:
0;0;;@
0.0;0.0;;@
There are four items in a custom format, by default the formats for
positive, negative, and zero values, and for text. Leave off the format
for zeros, and the label will not appear.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
