Maybe you have a leading space in front of each number...............try

TRIM(a1)

Vaya con Dios,
Chuck, CABGx3


"Confused on the tundra" <Confused on the
wrote in message ...
I've imported a long list of "numbers" from a server. Now in my excel
table I
can not sort them. I've tried multiplying the col. by "1" from paste
special,
Add from a free cell and paste special, using a macro form the converting
text to number page, using trim and clean function, copy and paste as
value,
using the text to columns command, all to no avail. The "numbers" still
stay
left justified and sort by first number, i.e. 113 before 21 etc.

There are 1500 entries and I do no think the table woudl be of much use
after i tried to re-type in all the numbers. The three numbers I did have
to
enter do work fine, and sort above all the other "numbers" . I have
several
columns that have "numbers" in them and woudl like to be able to sort, at
varoius time, by any one.