If you don't mind converting those values directly to dates....

Try this:
Select the vertical range of values

From the Excel main menu:
<data<text-to-columns
....click [Next] until Step 3 of 3
Set the "Column data format" to: Date MDY
Click [Finish]

Example:
These values
112482
60107
123105

Become these:
11/24/1982
6/1/2007
12/31/2005

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"MEAD5432" wrote:

I have a column of dates. These dates are stored in the cell as "112482" and
the cell is formatted as "00\/00\/00" so that in the cell it looks like:
"11/24/82".

The problem is, I can't sort these dates because they are not stored
correctly in the cell for Excel to recognize them like it should. For
instance, "112482" is seen by Excel as 112,482nd day after January 1st, 1900
or 12/18/2007.

It appears there is no function in Excel currently to format my dates
correctly so it can be sorted by Excel. Can I create one using VBA? What
would it be?