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

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

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

HTH
--
AP

"CARA" a écrit dans le message de
...
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