Excel cell showing Yr/Mo/Day in numbers only (09/11/06) can it b.

[Bongo]

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?

 

[Jacob Skaria]

--You can custom format to yyyy/mm/dd (Right click>FormatCells>Number>select
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