Sorting Rows With A Combination Of Text And Number?

I'm currently trying to make a sort macro that sorts a row of data that has a combination of numerical data and the text entry "N.A."

e.g.:

My field:
1
2
N.A
4
5
N.A
9

I want to sort the cells by descending value. But the result appears as:

My field:
N.A
N.A
9
5
4
2
1

But I want to numbers to appear first and have the "N.A."s to be after the number, since I have about 100 columns and some rows have like 30 N.A., which is pretty bad for usability if all that appears in the first screen are "N.A."

EDIT: by the way by ascending the data is fine since it orders by smallest number to largest and THEN the "N.A."