I've set up a worksheet in spotlight with columns for channel, fixture etc. and selected to sort via channel, however as some channels are single digit - 1,2,3 and some are 3 digits..101 etc the list when sorted goes 1,101,102,2,3,301,302 etc.
is there anyway i can get it to list in numerical order? so it would go 1 thru 99 then 100 onwards? i've looked in format cells and tried various number options with no luck.