Excel 5.0 entering date

  • Thread starter Thread starter Eric G
  • Start date Start date
E

Eric G

Think way back to Excel 5.0.
Actually it has a lot of nice features.

Can someone please tell me how I can easily enter dates in a column?
For example:

Jan 21-03
Feb 14-03
May 25-03
etc,

without doing any special coding each time?
If I type them in as above I can't sort by date.

Thanks! Eric
 
Eric G.


If you change the cell format to mmm dd-yy and then enter the dates as
19/01/03, the cell format should do te trick for you.

As the dates will then be stored internally as dates, the sort function
should have no problems.
 
Back
Top