BLOMASKY Not sure if I asked about this before, (if so, just blame the alzheimers!). But is there an easy way to zero suppress a #? Numeric format of ###,### still prints zero thanks Bruce
tford It's kind of a pain, but I use conditional formatting to make zero values invisible .. make the font the same color as the background.