Excel sorting

J

Juan Kermode

I had a membership list on Access which was converted to
Excel.

When I try to 'sort' the members by membership numbers all
the new members' numbers that have been inputted since the
setup of the Excel spreadsheet appear at the top of the
list and before the 'old' membership numbers.

I need those members correctly sorted into proper
numerical order - any help would be gratefully received.

Many thanks

Juan Kermode
Everton FC Supporters Club, Isle of Man branch
 
E

Excel Semi Pro

One of your lists of numbers has probably been put in as text. Excel will sort the numbers first and then sort the text and put those at the end. You may have to convert all to numbers and then resort.
 
Top