Auto negative entry

[Darrell Shuman]

How do I format a cell to automatically add brackets to the number entry to
show it is being subtracted by a formula that is elsewhere. Or, how do I
make the entry automatically negative (will adjust formula to keep from
subtracting a negative.)
Thanks
Darrell

 

[Gord Dibben]

To just show a number as (1234) in red you can Custom format to

[Red] (#,##0.00)

The number will not be negative however.

To get truly negative numbers as you type them in you would need event code.


Gord Dibben MS Excel MVP