Enter credit (negative number) in sales template

G

gdusseau

Excel 2002
Sales Invoice.xlt
What do I have to change in the template to enter a credit?
Only positive numbers can be entered in the template.
 
G

Gord Dibben

A negative amount is normally referred to as a "debit"

Credit is a positve amount.

First you must go to Tools>Protection>Unprotect Sheet........no password
required.

Second select the cells L19:L39 and Data>Validation>Clear All.


Gord
 
Top