Negative value in Excel

  • Thread starter Thread starter adhanya
  • Start date Start date
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
 
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.
 
Back
Top