Thanks very much, but it didn't work. The reason I don't think it's a text
problem is because all the other ones sort in order and I have SB in from of
them all ... in the same databse is House Bills and those are entered as HB
4044 4055 etc. and all those sort correctly, so it's just odd!!

"Max" wrote:

"Kerri" wrote:
When I tell my excel sheet to sort it sorts correctly up to 99, but then
seems to recognise the 1000's as 100's because it then goes to the 1000's,
then puts the 200's after that etc....

Probably text numbers .. try converting to real numbers:
Copy an empty cell in another col
(clear the cell with the Delete key first to be sure)
Then select the col of "numbers",
Right-click paste special check "add" ok
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---