Hi
For serial number 1 in A1 just type 1
For the second serial number type =A1 + 1
Fill this formula down and you will get the sequence 1, 2, 3, ..
Deleting any row will re-number automatically as you required.

regards
Paul

ReD-DevIL wrote:
Hi, I have a serial number for every equipment.

E.g.

sno date
1 21-mar-06
2 22-mar-06
3 23-mar-06

Once the user delete the number 2 records, the number 3 will move up
but the serial number remains as 3 how can i code it to adjust the
serial number when a record is removed ?