which people do use roman numbers for their daily work regularly?

Those who are living permanently in Rome, how do they write 4000 to above number in roman system ?
f haqueASI BD PoliceAsked:
Who is Participating?
 
Tom CieslikIT EngineerCommented:
Hahaha,,, there is a catch in your question

Excell has predefined converted for Arabic to ROMAN numbers but maximum number is 3999

So if you'll put 3000 in A1 and in A2 you'll put =ROMAN(A1) you'll get MMMCMXCIX
but if you'll put 4000, there is an error

There is only one way to do it by installing 3rd party Excel ad-on

It's called KUTOOLS for Excel

You can try for no limitation for 60 days, then you muast purchase it

https://www.extendoffice.com/product/kutools-for-excel.html

Capture.JPG
Capture.JPG
0
 
☠ MASQ ☠Commented:
People in Rome now will write 4000
People in Rome 2000 years ago would write MMMM
https://www.rapidtables.com/convert/number/roman-numerals-converter.html
0
 
David FavorLinux/LXD/WordPress/Hosting SavantCommented:
Roman Numerals 1-5000 is a good starting point.

4000 = IV with bar over top. Unsure how to render this as HTML, if that's what you're asking.

Likely I'd find a Roman Numeral font, if I had to render many Roman Numerals on a regular basis.
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
f haqueASI BD PoliceAuthor Commented:
I want to write roman number from 4000 to above in excel.
0
 
Tom CieslikIT EngineerCommented:
1000 is M
so 4000 = MMMM


Cardinal      four thousand
Ordinal      4000th
(four thousandth)
Factorization      2(5)× 5(3)
Greek numeral      ,Δ´
Roman numeral      MMMM or MV
Unicode symbol(s)      MV, mv
Binary      1111101000002
Ternary      121110113
Quaternary      3322004
Quinary      1120005
Senary      303046
Octal      76408
Duodecimal      239412
Hexadecimal      FA016
Vigesimal      A0020
Base 36      33436
0
 
Tom CieslikIT EngineerCommented:
How to convert ROMAN MMMM number in Excel to Arabic you can find here

https://www.extendoffice.com/documents/excel/1769-excel-convert-numbers-to-roman-numerals.html
1
 
EirmanChief Operations ManagerCommented:
Which people do use roman numbers for their daily work regularly?
To answer your exact question ...

People who add the year to movies credits use them.
You will see them on clocks and some book page numbers.
More details here ... http://www.web40571.clarahost.co.uk/roman/use.htm
0
 
☠ MASQ ☠Commented:
Tom, there are multiple comments here that address the question, not seeing how you justify choosing your own as "Best solution provided", but even if that were so do you think none of the other suggestions are valid?
0
 
Tom CieslikIT EngineerCommented:
MASQ, please read careful all comments, I see only one suggestion. All other one are interpretation.

The question was"how do they write 4000 to above number in roman system" so only one way to do it in Excel is by 3rd party software.
If you think is not true, please write number and upload spreadsheet
0
 
EirmanChief Operations ManagerCommented:
The headline of the question, and therefore the main question was .....
"Which people do use roman numbers for their daily work regularly?"

I was the only person who addressed the main question.
(the 4000 query should be treated as an appendix to the main question)
0
 
Tom CieslikIT EngineerCommented:
Excel has a limit in Roman numbers and maximum number is 3999
That's why you must use 3rd party solution.

I've spend a lot of time looking for the answer in internet and I asked my friends from Europe who are guru in Excel creating scripts on every day basics for accounting companies and they've told me, it can;t be done by script. Maybe they're wrong but so far I did not found any other resolution than KUTOOLS
0
 
EirmanChief Operations ManagerCommented:
Seems like a fair distribution of points based on the Mod's first intervention.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.