Anything that has a text value (1a, 1b, 1c), gives me a #VALUE error and it
still wants to sort as a text value. Any other suggestions?

Thanks!

"Bob Phillips" wrote in message
...
Karl,

IN an adjacent column add this formula

=--A1

copy down and then sort by the helper column.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Karl Burrows" wrote in message
...
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!