Excel 2007

I have two columns of data. Column A is a text field and column B is a
number field. I want to sort the data, first by column A and then by column
B. When I use the Sort screen, the Order item for column A (text field) gives
the option A to Z or Z to A, which is correct. The Order item for column B
(numbers field) also gives the option A to Z or Z to A. This is incorrect. It
should give smallest to largest or largest to smallest.

I do have the option to go into the Custom List in the Order item and add
smallest to largest or larget to smallest. I have tried this but the sort in
colmn B does not come out correct.

Thinking the worksheet may be corupt, I copied columns A and B to another
worksheet and I am experiencing the same problem.

Any suggestions.

Thank you,

Bill