Negative Numbers in Cells

R

rob

Is there a way to format a cell so that no matter how you enter a number it
will always be negative? I.E. enter in 28.50 and the cell automatically
makes it (28.50).
 
D

Dave O

One way to do this is by adding a column with formulas that refer to
the column in which you enter numbers. For instance if you enter data
in A1, the formula in B1 might be something like
=ABS(A1)*-1

This takes the absolute value of A1 and multiplies by -1, returning a
negative number. The absolute value is in there just in case you enter
a negative number.
 
B

Bob Phillips

You could try a custom format of

(General);(General);General

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top