| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting Numerical Values...
I'll probably slap myself when someone shows me how to do this, but I'm
stuck... I've got a series of values in a column as follows: 10 Mb 10 Mb 1000 Mb 1000 Mb 114 Mb 128 Mb 128 Mb Obviously 1000 mb is more than 10 mb, but it sorts as second in the list because it starts with a "1". How do I tell Excel to sort by the entire numerical value instead of the first number? Thanks in advance :-D |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Associated Numerical Values | Excel Discussion (Misc queries) | |||
| How can I break values apart that are in the same cell? | Excel Worksheet Functions | |||
| Scatter chart without numerical values | Charts and Charting in Excel | |||
| is there a way to change formulas to values for sorting purposes? | Excel Worksheet Functions | |||
| How do I stop excel replacing numerical values with the date? | Excel Discussion (Misc queries) | |||
Threaded Mode
