You could create a Helper column
=MID(A1,4,4)
then sort 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