Negative Numbers in Cells
 

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).

Negative Numbers in Cells
 

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.

Negative Numbers in Cells
 

You could try a custom format of

(General);(General);General

--

HTH

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


"Dave O" wrote in message
ups.com...
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.