Posted by Matt Schmitt on July 02, 2001 9:29 AM
I am manipulating a text file using excel. When I break it out into columns, the date colums is a number. 12101 would be Jan 21, 2001. I went to format and custom, to make the date appear as 01/21/01. Now I need to sort the date column in ascending order. The sort puts the dates in numberic order. 05/21/97 will appear after 01/21/01. If I change the format of the column to date, Excel recognises it as a serial number instead of the actual date. How can i sort this column to put it in the order I need?