negative number display

[Dave]

I got this answer here before but lost it!
How do I get a number to disply as a negative number even if it is entered
as positive?
in other words i enter 45 but -45 appears.
I thought someone gave me a macro for this but i can't find it
thanks

 

[hcj]

If you want the number only to APPEAR as negative, format
the cell using Custom and "-"0.0;-0.0
This will not make a positive number negative - just stick
a "minus sign" in front of it. Actual negative numbers
will appear as usual. Adjust the 0.0 as you wish for
display.

If you want the number to actually BE negative, regardless
of input, then you'll have to have a separate cell to hold
the result =-abs(a1) for a number entered in A1.

HTH

 

[Dave]

Thanks
yeah, I am pretty sure the last time I did this someone came up with a macro
that I could set a range that would behave this way. So that any number
entered would be made negative and would also work as a negative number in
and formulas or sums.
hmmmm....

 

[Dave]

ok...got it!

Thanks
yeah, I am pretty sure the last time I did this someone came up with a macro
that I could set a range that would behave this way. So that any number
entered would be made negative and would also work as a negative number in
and formulas or sums.
hmmmm....