The simplest way is to use two cells:

Enter your data in A1 and in B1:

=-A1

Thus saving a keystroke.

Another way involves event macros.
--
Gary''s Student - gsnu200755


"GeeTee" wrote:

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