| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I sort by the first digit of a number?
Hi Laura,
This macro will change existing numbers to text: Sub TextToNumbers() Selection.TextToColumns Destination:=ActiveCell, DataType:=xlFixedWidth, FieldInfo:=Array(0, 2) End Sub Highlight the cells containing numbers that you want to change to text and run the code above. Once that's done, you can sort them, and they will then indeed be in the order you requested. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to validate a cell to insert from 9 digit number to 13 digit number. | Excel Worksheet Functions | |||
| How to validate a cell to insert from 9 digit number to 13 digit number. | Excel Worksheet Functions | |||
| Color a single digit in a mult-digit number cell | Excel Discussion (Misc queries) | |||
| Tell users how to sort 5 digit and 9 digit zipcodes correctly aft. | New Users to Excel | |||
| When we enter a 16 digit number (credit card) the last digit chan. | Excel Discussion (Misc queries) | |||
Threaded Mode
