Negative value in Excel

A

adhanya

I would like value in a certain rage of cells to always be negativ
without adding minus sign when enter the value. Does anyone know how t
set this??? Many thanks
 
E

Earl Kiosterud

Adhanya,

One solution is to put the values in straightaway (as positive), and simply
make them look as though they're negative. Select the cells, Format, Cells,
Number, Custom, and use something like:

-General
-0.00

Then in any formulas that refer to them, negate them so they will be treated
as negative.

Or an event macro can negate them as they're entered.
 
Top