View Single Post
  #3   Report Post  
Gary's Student
 
Posts: n/a
Default

You will need to convert the Roman numerals into numbers that Excel can sort.
See:

http://groups-beta.google.com/group/...bd85d9e5?hl=en
--
Gary's Student


"Hokie Bear" wrote:

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!!