i'm looking to convert a number to a date so i can sort by date. for instance, if i have a number like 101502. how do i get it to be recognized as 10-15-02. the only way i could get it to look like that was to go to format cells-custom, and type in ##-##-##. This works, but when i sort by date, it won't go from latest date to most current. if this is possible, i could use all the help i can get. thanks.