That will "display" only.

The number will still be positive.


Gord Dibben MS Excel MVP

On Sun, 21 Sep 2008 08:42:01 -0700, Candicehkjc
wrote:

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.