How to sort with zeroes

K

KC

I have a list of numbers that I need to have sorted. When I do a regular
sort - this is how the data comes out:

5601 132471 56010009621 100012976 3.40 298.000000
5601 132471 56010009621 100009721 4.02 298.000000
5601 132471 56010009621 100111974 0.54 298.000000
0101 110201 20010100150 100001981 79.03 2105885.000000
0101 110201 20010100150 100001982 27.85 2105885.000000
0101 110201 20010100150 100002483 6.32 2105885.000000

I need the line with the leading zero to be the top lines. I have used
text to columns and I have tried to do @value. Nothing seems to work. Any
suggestions?
 
G

Gord Dibben

The numbers with leading zeros are most likely text, not numeric.

Copy an empty cell then select the data and Paste Special>Add>OK>Esc.

The 0101 will change to 101. Now sort the column.

Format as Custom 0000 to see 0101

Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

function result losing leading zeros 3
REPLACE command drops leading zeros 4
Using REPLACE command removes leading zeros 2
Sort column beginning with blank? 1
Style Gallery View 3
Unwanted line across top of pages; how to delete? 0
sort by numbers of digits in cells 4
Sorting in Excel 2

Top