| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Sort text Values in Numeric Order
I changed a field type in Access from Number to Text to allow 1a, 1b, etc.
and now when the data is imported into my Excel workbooks, the order is still sorting as text (1, 10, 100, 101, 2, 20, etc.). Any thought son how to get it to sort correctly now? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Assign numerical values to text codes | Excel Worksheet Functions | |||
| Count how many different text values in an array. | Excel Worksheet Functions | |||
| Need to sort dates before 1900 in proper order | Excel Discussion (Misc queries) | |||
| Graph values in ascending order | Excel Discussion (Misc queries) | |||
| text and values combined in one cel | Excel Discussion (Misc queries) | |||
Threaded Mode
