Force descending sort to Start with Numbers

Here is an example of my spreadsheet:

Player GP G A PTS PT/G SH P P PMS

Spare _ _ _ _ _ _ _ _ _
Spare _ _ _ _ _ _ _ _ _
Spare _ _ _ _ _ _ _ _ _
Ray 4 2 2 4 1.00 0 0 0
Steve 5 2 2 4 0.80 0 0 0
Dave 3 3 0 3 1.00 0 0 0
Brian 2 1 1 2 1.00 0 0 0
Denis 1 1 0 1 1.00 0 0 0
Al 0 0 0 0 0.00 0 0 0



I have a macro to sort Points(PTS) descending, Points/game(PT/G) descending, then Goals(G) descending.

The cells in this sheet are links to a master records sheet. Spare Players have values of N/A.

Problem is when Excel Sorts Descending it puts the N/A's First then the numbers.

How can I get the Spare(N/A) values to be listed last and still have my numbers descending?

Replace N/A with a slash / (ASCII 47)
Sort the data then replace the slash with N/A

You're quite right! I hadn't tested it.
If you add a ' before each number to turn it into Text, Excel will sort as ASCII, but it will issue a warning.