"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
---