| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CONVERT ROMAN TO ARABIC NUMERALS
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
CONVERT ROMAN TO ARABIC NUMERALS
And your question is ???
Pete On Oct 8, 3:55 pm, JOHN wrote: |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
CONVERT ROMAN TO ARABIC NUMERALS
http://en.wikipedia.org/wiki/Roman_numerals
Nothing built in and unless somebody has built anything in Excel that will do this I'd suggest you roll your own -- Regards, Peo Sjoblom "JOHN" wrote in message ... |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
CONVERT ROMAN TO ARABIC NUMERALS
=MATCH(A1,ROMAN(ROW($1:$3999)),0)
ctrl+shift+entered with Tools Addins: Analysis toolpak checked. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Thank u so much!!!
you rock if ihadnt read this i woulndnt no how to do
this!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!! "Lori" wrote: =MATCH(A1,ROMAN(ROW($1:$3999)),0) ctrl+shift+entered with Tools Addins: Analysis toolpak checked.rock on |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
CONVERT ROMAN TO ARABIC NUMERALS
Hi all,
Why this is not working when reffering other than A1 cell (row 3) ? =MATCH(A3,ROMAN(ROW($3:$3999)),0) - does not work?? Thanks for hints, Jan "Lori" wrote: =MATCH(A1,ROMAN(ROW($1:$3999)),0) ctrl+shift+entered with Tools Addins: Analysis toolpak checked. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
CONVERT ROMAN TO ARABIC NUMERALS
I'm sorry. it works well. just I left a space at the end of roman number in
cell, Bye, J. "JanV" wrote: Hi all, Why this is not working when reffering other than A1 cell (row 3) ? =MATCH(A3,ROMAN(ROW($3:$3999)),0) - does not work?? Thanks for hints, Jan "Lori" wrote: =MATCH(A1,ROMAN(ROW($1:$3999)),0) ctrl+shift+entered with Tools Addins: Analysis toolpak checked. |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
CONVERT ROMAN TO ARABIC NUMERALS
On Wed, 14 Apr 2010 03:42:01 -0700, JanV
wrote: Hi all, Why this is not working when reffering other than A1 cell (row 3) ? =MATCH(A3,ROMAN(ROW($3:$3999)),0) - does not work?? Thanks for hints, Jan What does "does not work" mean? Excel crashes? Error message? If so, what is the message. Wrong result? If so, what is your input and output. What you posted shows $3:$3999 for the array which is incorrect and not the same as the original and, even if everything else were correct, would give an incorrect answer. This is something that can change if you insert rows. If that is the issue, then: =MATCH(A1,ROMAN(ROW(INDIRECT("1:3999"))),0) entered as an array formula by holding down <ctrl<shift while hitting <enter will allow row insertion without changing the references. Maybe you didn't enter the formula as an array formula. Maybe the contents of A1 is not a roman numeral in the proper format. --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I convert Roman numerals to Arabic (reverse of ROMAN)? | Excel Worksheet Functions | |||
| Convert numbers (numerals) to words (text) | Excel Discussion (Misc queries) | |||
| Enabling Arabic numerals in Excel | Excel Discussion (Misc queries) | |||
| Sorting data using roman numerals.... | Excel Discussion (Misc queries) | |||
| Function for Roman Numerals | Excel Worksheet Functions | |||
Hybrid Mode
