converting numbers to date

[rekless44]

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.

 

[IML]

consider using text to columns.

Select it from the date menu, hit next, next again, select the date radio dial with you mdy format, and finally hit finish.

If you always use a two digit day you should be fine, otherwise beware of dates like
11102. This will be picked up as January 11.

 

[stevebausch]

Is your "number" really a number? If it is a cell value, I think it's a variant, right?

You could use Mid() to insert your chosen delimiters, and then reassign the new string to .Value.

This technique may be sensitive to how the cell is formatted.

Once it looks like a date, do you want it to have a serial value, like a "real" Excel date?

 

[rekless44]

looks like it works. thanks