I changed a field type in Access from Number to Text to allow 1a, 1b, etc.
and now when the data is imported into my Excel workbooks, the order is
still sorting as text (1, 10, 100, 101, 2, 20, etc.). Any thought son how
to get it to sort correctly now?

Thanks!