ARABIC

ARABIC(text)

Returns the number converted from roman to arabic.

textThe text to convert.

REMARKS
* If "text" contains numbers, then #VALUE is returned.
* If "text" contains dates, then #VALUE is returned.
* If "text" contains text that is not valid roman numerals, then #VALUE is returned.
* If "text" is an empty string, then 0 is returned.
* The "text" has a maximum length of 255 characters.
* The case of "text" is ignored.
* Any leading or trailing spaces are ignored.
* This function was added in Excel 2013.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

 A
1=ARABIC("MMXI") = 2011
2=ARABIC("") = 0
3=ARABIC("some text") = #VALUE!
4=ARABIC(100) = #VALUE!


© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top