Auto negative entry
 

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

Auto negative entry
 

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


On Fri, 9 Mar 2007 10:32:21 -0500, "Darrell Shuman"
wrote:

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