software

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

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