C
cmajor335
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
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