Simple, put 1 less of the actual number


"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?