Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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). |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating growth with negative numbers | Excel Worksheet Functions | |||
how to find duplicate cells in large array of numbers | Excel Worksheet Functions | |||
Cells formated as numbers are calculating like text | Excel Discussion (Misc queries) | |||
BRACKETED NEGATIVE NUMBERS IN EXCEL | New Users to Excel | |||
Subtracting Negative Numbers | Excel Worksheet Functions |