Auto FIll on Templates with no value displayed

[mrwong]

Hi - can anyone tell me how you create an invoice template that calculates across the qty by cost per item and total in a way that doesn't display zeros in all the total columns in a template where you dont actually have any values yet. At thje moment we jsut do the top line but then each time you create a new invoice from the template you have to drag the formula fill vertically to apply to each line item in the invoice. I am sure there must be a way to hide the zeros in a template until you actually add some values to the invoice.

Thanks

[shg]

Format the cells to suppress display of zero; e.g., General;-General;

[Little Master]

Method I
Go to Tools -> Options -> View -> uncheck Zero Values.



Method II

1. Select the cells that contain the zero (0) values that you want to hide.
2. On the Format menu, click Cells, and then click the Number tab.
3. In the Category list, click Custom.
4. In the Type box, type 0;-0;;@