Thread: Enter credit (negative number) in sales template
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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 With QuoteReply With Quote