Hello

In my excel spreadsheet, the first column will always contain either a number or nothing.

So, it would look like this...

Column
[ 1 ]
[ ]
[ 2 ]
[ 3 ]
[ ]
[ 4 ]

Is there any way to enfore the numbering is incremental? This means something like the following should never be allowed -


Column
[ 1 ]
[ ]
[ 3 ]
[ 2 ]
[ ]
[ 4 ]

(note I swapped the 2 and 3)

Can this be done?

Any help appreciated.

Thanks!

Steve