--You can custom format to yyyy/mm/dd (Right clickFormatCellsNumberselect
Date or select Custom and enter yyyy/mm/dd)

--If you enter the dates in excel date format.you can do the sorting in asc
or desc as excel stores the dates as numbers

Just check out the below link by Chip
http://www.cpearson.com/excel/datetime.htm


If this post helps click Yes
---------------
Jacob Skaria


"Bongo" wrote:

I want to create an excel column that will show yr/mo/day all in numbers so I
can easily sort. Can this be done?