| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Sorting data using roman numerals....
Is there any way to sort data using Roman numerals as the "sort by" column?
Excel treats it as text and places IX before V. I can make it work by adding a column and manually converting the Roman numerals to regular numbers and sorting on that, but for some of my reports, that too much data to manually convert. Come on guys, make me look like a hero!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to maintain hyperlink when sorting data? | Excel Discussion (Misc queries) | |||
| Automatically sorting data | Excel Discussion (Misc queries) | |||
| Sorting Data from 2 sheets, one sheet which is already sorted | Excel Worksheet Functions | |||
| Hyperlinks and sorting data | Excel Discussion (Misc queries) | |||
| how do you prevent data from changing values when sorting linked . | Excel Discussion (Misc queries) | |||
Threaded Mode
