1,5,12 stored as numbers sort as: 1,5,12. When stored as text, they sort as
1,12,5. You're being asked how you want to sort the data.

Tyro

"Chris" wrote in message
...
On occasion, when I sort an Excel worksheet on a field that is defined as
text and is all numbers, I get a sort warning:
The following sort key may not sort as expect? 1. Sort anything that looks
like a number, as a number? 2. Sort numbers and numbers stored as text
separately?

Frequently it occurs when I have imported a text file into Excel.

--
Thanks!
Chris