View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Matlock Matlock is offline
external usenet poster
 
Posts: 25
Default 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?