I'm not having a good day. <g
Doesn't work for me either unless you go thru the F2 thing on each cell.
It will work if the cells are formatted as text before manual data entry.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"Toppers"
wrote in message
Formatting as TEXT don't work!
"Jim Cone" wrote:


Format the data as Text then sort.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel add-ins)


"laura3511"
wrote in message
I'm trying to sort a list of part number like this:
10, 54, 94, 101, 1800, 200, 2000, 500

The only way I can find to sort them is:
10, 54, 94, 101, 200, 500, 1800, 2000

What I need is them sorted by the first digit and then the entire number:
10, 101, 1800, 200, 2000, 54, 500, 94

Is there any reasonable way to do this without manually creating another
column that has the first digit in it?
Any help would be greatly appreciated.