Negitive Numbers

C

CEP

How do I formate a cell so the number will always be negitive w/o using a
negitvie sign.
 
J

Jim Rech

One number format of many possible ones is: -#,##0;-#,##0;0

But we aware this makes a number "appear negative", not "be negative". A
positive number will still be positive for purposes of math operations, as
indicated by what you see in the formula bar.
 
Top