HOW DO I RE-NUMBERED MY NUMBER COLUMN AFTER I ADDED ROWS?

my sheet is set up this way:
no# date name
1 4/13/06 JOHN
2 4/13/06 JOHN
3 4/13/06 JOHN
4/13/06 JOHN
4/13/06 JOHN
4 4/13/06 JOHN
5 4/13/06 JOHN
i HAD ENTERED INFORMATION ACCORDDINGLY BUT I LEFT OUT SOME NAMES IN BETWEEN
ROWS SO I WENT BACK ADDED ROWS IN BETWEEN AND OF COURSE THE NEW ROWS AREN'T
NUMBERED SO I WANT TO RE-NUMBERED OR SORT OUT
THE NO# COLUMN SO IT IN ORDER.
AS YOU CAN SEE ON THE TOP THE TWO ROW THAT I ADDED AREN'T NUMBERED AND I
DONT HAVE A CLUE IN HOW TO DO IT W/O AFFECTING THE TEXT

Enter following formula in A2, then copy down:
=ROW()-1

HTH
--
AP

"CARA" <[email protected]> a écrit dans le message de
news:[email protected]...
> my sheet is set up this way:
> no# date name
> 1 4/13/06 JOHN
> 2 4/13/06 JOHN
> 3 4/13/06 JOHN
> 4/13/06 JOHN
> 4/13/06 JOHN
> 4 4/13/06 JOHN
> 5 4/13/06 JOHN
> i HAD ENTERED INFORMATION ACCORDDINGLY BUT I LEFT OUT SOME NAMES IN
BETWEEN
> ROWS SO I WENT BACK ADDED ROWS IN BETWEEN AND OF COURSE THE NEW ROWS
AREN'T
> NUMBERED SO I WANT TO RE-NUMBERED OR SORT OUT
> THE NO# COLUMN SO IT IN ORDER.
> AS YOU CAN SEE ON THE TOP THE TWO ROW THAT I ADDED AREN'T NUMBERED AND I
> DONT HAVE A CLUE IN HOW TO DO IT W/O AFFECTING THE TEXT