7 Day Automatic Imput
I am looking for a way to type in 1st (with the 'st') and then the 2nd (with
the 'nd') comes up for the next date. Insted of 2, or 2/2/02 or 2/2.
I type '1' and it turns it into '1st'.
Or..
Is there a way to type in a colum of dates 1st - 31st with the letters after
example...
1st
2nd
3rd
4th
5th
6th
And possibly have a formula so when I type '1st' in one cell, the next cell
automaticly imputs the next number down the colum.
Another way to look at it is..
Jay
Billy
Kevin
I type in 'Billy' and 'Kevin' automaticly is placed in the next paticular
cell?
Fallow?
|