Mark,

There is no built-in way to do that.
Setting up your numbering system so that all numeric entries
were the same length (1234, 0234, 0004) would be best -
if you had a time machine.<g

The Special Sort add-in I mentioned will sort the way you want.
Also, someone may yet offer a formula fix the numbers.
I've seen Leo Heuser and others work miracles.

Regards,
Jim Cone
San Francisco, USA


"mark1caroline"

wrote in message
news:mark1caroline.1s3m70_1121241945.1036@excelfor um-nospam.com...
Hi Jim, Thanks for reply.
Is there not a string of logical numbers and or letters that could be
entered into a sheet that would sort in order? There must be a simple
answer to this annoying problem I have It would really need to
contain both letters and numbers to make sence to stores staff. Excel
is such a powerful tool yet what appears to me to be a simple sort can
not be achieved.
Mark