I am entering values where 95% are whole amounts (no cents). I format the
cells to show without decimal point. When I do enter an amount with cents I
want it to show in chart but only where there is cents. Is there a way to
format without having to manually change every time I have cents?

bobby