Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sorting a sheet
Hello:
I have a problem in sorting a sheet. I choose column A to sort in ascending order, which is does... with 1 problem. Excel usually sorts by the first digit; these spreadsheets are sorting numerically. 333 is being placed before 330A, and 333 is being placed before 1234. and no, it is not a matter of sorting from z-a or a-z. How can I get the sort to like it normally does? Thanks for any help... John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Impoting data from Sheet 1 to Sheet 2 | Excel Discussion (Misc queries) | |||
relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) | |||
linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
Function to automatically insert a new sheet as a result of data entry? | Excel Worksheet Functions | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |