Select the column with the numbers.

DataText to columnsNextNextColumn Data FormatDateMDYFinish


Gord Dibben MS Excel MVP

On Thu, 28 Jun 2007 08:46:04 -0700, 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?