View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Candicehkjc Candicehkjc is offline
external usenet poster
 
Posts: 2
Default Negative numbers

Selet the cell, then select format cells Select Custom and type -0. Then all
integer input with change to negative. e.g. type 123 will display -123.

"Vercingetorix.XIII" wrote:

Is there a way to make a number be a negative number when it is entered in? I
need to add a total of figures and have it subtract from another total.