What's happened to the Sort in 2007?
 

for the last 13 years I have used Excel. In sorting our article numbers I
have only had a problem of forgetting to format the column as TEXT, this
looses the leading zero many of our numbers have. Now though EXCEL wants to
sort by value as in the left column, how do I change it to sort like the
right column.
18931 098921
18941 189211
18942 189215
098921 189220
189211 189266
189215 18931
189220 189310
189266 18941
189310 18942
199301 199301
199302 199302

Many thanks
Cmajor335

What's happened to the Sort in 2007?
 

You must keep your columns as TEXT. Try to add empty string so Excel will
recognize values as TEXT and not as number. Spend 1 columns with...
= A1 & "" - that will make A1 TEXT

Do it for all vaue and sort the TEXT column.


"cmajor335" wrote:

for the last 13 years I have used Excel. In sorting our article numbers I
have only had a problem of forgetting to format the column as TEXT, this
looses the leading zero many of our numbers have. Now though EXCEL wants to
sort by value as in the left column, how do I change it to sort like the
right column.
18931 098921
18941 189211
18942 189215
098921 189220
189211 189266
189215 18931
189220 189310
189266 18941
189310 18942
199301 199301
199302 199302

Many thanks
Cmajor335