| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Enter credit (negative number) in sales template
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Enter credit (negative number) in sales template
A negative amount is normally referred to as a "debit"
Credit is a positve amount. First you must go to ToolsProtectionUnprotect Sheet........no password required. Second select the cells L19:L39 and DataValidationClear All. Gord On Mon, 1 Jan 2007 15:25:00 -0800, gdusseau wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| negative number to positive number | Excel Discussion (Misc queries) | |||
| Force function to show positive or negative number? | Excel Worksheet Functions | |||
| Change number when you open the excel template | Excel Discussion (Misc queries) | |||
| How do I replace a negative number at the end of a formula with a. | Excel Discussion (Misc queries) | |||
| When we enter a 16 digit number (credit card) the last digit chan. | Excel Discussion (Misc queries) | |||
Linear Mode
