Wendy

How about a Spinner from the Forms toolbar.

Then you could go down or up as you choose.


Gord Dibben MS Excel MVP

On Tue, 6 Feb 2007 14:57:00 -0800, Wendy
wrote:

I would like to format a cell that each time a number is typed in it will
subtract 1 from that number. I do not want to put a formula in another colum
to do this, just when I type in a 5 for example the 5 would change to a 4.
Can this be done?