I have several columns with data in. When I want to sort by a specific column which contains numbers it won't do as I want it. Instead of going 1, 2, 4 etc it goes 1, 10, 110, 2, 220, 45 etc. How do I change this so it goes in number order please?
One way is to format the cells with a custom format e.g. 00000 then the sort should work but I bet VoG has a better way:o)
Oh, and you can remove the custom format after sorting.
Excel is assuming that the cells contain text, not numbers. You will need to format the cells as numbers.
Quizman your suggestion doesn't work. Thanks anyway.
dazwmDo the columns that you want to sort have both text and numbers in them?
Yes they do, however this particular column just has numbers in it.
As said above, the 'numbers' are stored as text. Select the cells, Format > Cells and change to Number.
I have done that and to no avail they just list 1 , 11 , 110 , 1000 then 2 etc
OK, try this. In another column in row 1 enter=--(A1)(change A to the letter of the actual column).then copy the formula down as far as needed. Try sorting by that new column.
This thread is now locked and can not be replied to.
Xiaomi Mi Mix 2 review
What went wrong at the Designs of the Year 2017
iPhone X news: Release date, price, new features & specs
Comment utiliser Live Photos ?
© Copyright 2017 IDG UK. All Rights Reserved.