Hi,
Try this in another column enter

=Trim(A1)

I assume column A is where you have that numbers, then copy as value on top
of the others an sort it

"slhiaz" wrote:

I am working in an Excel 2007 spreadsheet and one very long column of normal
numbers are not sorting. for Example:

407
408
102
103
104

Everytime I try to sort this ascending, it does nothing.