I tend to respond to the question asked unless it is ambiguous or clearly
mis-stated.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Stephen" <none wrote in message
...
But be aware that this changes only the way the number is shown, not the
underlying value. So if the value is then used elsewhere in a formula, the
positive value will be used, which I would find very confusing. Whilst
this is exactly what the OP asked, it may well not be what was wanted!
Certainly the OP should be made aware of this.

"Bob Phillips" wrote in message
...
(General);(General)

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"GeeTee" wrote in message
...
Can I format cells so that any number entered into it is shown as
negative
automatically ie not having to make the entry with a minus sign


Thanks