Use another column with formulas like:

=mid(a1,4,4)

and then sort your data by that column.

tcidawn wrote:

We use a custom formatted number ##-####-## I need to be able to sort by
the middle four digits for a report. Can someone help me please? I have
done it before, but I am having a brain freeze.

Thanks

--

Dave Peterson