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

Hi Hokie Bear

Instead of manually converting the Roman numerals why not use a lookup
table

In a separate area of the sreadsheet create a table with Col 1 Roman
Numerals Column 2 Regular numbers

then in the column next to your roman numerals use the VLOOKUP function
to return the value for you


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=397231