PDA

View Full Version : Excel 2000 sort problem



jupiter1
16-12-2005, 08:45 PM
When I sort colums of numbers in excel I get :-
1 followed by 10, 11, etc.
then 2 followed by 20, 21, etc.
and so on.

How can I stop this without entering preceeding zeros.
I can't seem to find anything in the help files.
cheers,

pctek
16-12-2005, 09:41 PM
Really? I just tried it - I clicked Sort off the menu choose the column I wanted, ascending and it went normal 1,2,3,10,11 etc.

godfather
16-12-2005, 10:07 PM
This is happening because the "numbers" are formatted as "text", possibly because they were imported or copied from a document.

You need to convert them to real numbers, sometimes just formatting the cell is not enough.

Put the number 1 in a spare cell.
select that cell, edit - copy

Then select the row of "numbers" that are in "text" format, edit - paste special - select values - multiply - OK

That will convert the "text" to numbers, it should now sort.

jupiter1
17-12-2005, 08:57 PM
Yo, thanks GODFATHER, that worked.
for some reason PCTEK's doesn't.
Might try a re-install !
Anyway I'm fixed for now, many thanks to you both.
Phil.

godfather
17-12-2005, 10:20 PM
That's because pctek's sort column wasn't in text mode, as yours was.

A reinstall is not required, if you sort on a text field it does an alpha sort, which was the result you were getting.