+ Reply to Thread
Results 1 to 13 of 13

Converting Decimal number into Arabic Text

  1. #1
    Registered User
    Join Date
    06-12-2012
    Location
    Jeddah, KSA
    MS-Off Ver
    Excel 2007
    Posts
    13

    Converting Decimal number into Arabic Text

    Dear

    I am referencing my question with the Solved thread
    HTML Code: 
    It is giving the perfect result as nedded by converting numeric into arabic text, except that it ignores decimal number.

    Can anybody help me in providing me the code to be added to work in same way for 2 digits decimal only

    Your help is always appreciated.

    Noman

  2. #2
    Registered User
    Join Date
    06-12-2012
    Location
    Jeddah, KSA
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: Converting Decimal number into Arabic Text

    Dear Genious members

    Please help me.

    I make the formula to solve the above issue, but the formula become too long. Below is the formula, which i want to be added to the macro code of the sheet attached (in last post)

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Your help will be highly appreciated.

    Regards
    Noman

  3. #3
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: Converting Decimal number into Arabic Text

    Can you give some examples of input and the desired output?
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

  4. #4
    Registered User
    Join Date
    06-12-2012
    Location
    Jeddah, KSA
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: Converting Decimal number into Arabic Text

    Quote Originally Posted by mikerickson View Post
    Can you give some examples of input and the desired output?
    Yes

    Please find attached file

    I have also provided some translation of Arabic words into english, so it will be understandable for you.
    Attached Files Attached Files

  5. #5
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: Converting Decimal number into Arabic Text

    I don't have the fonts for Arabic, but if you have an existing "function" IntegerToArabic (perhaps as combination of UDF and Excel formulas) (IntegerToArabic would not append units or "Only")

    If you had a money amount in A1, you could use

    = IntegerToArabic(INT(A1))&" Riyal"& REPT(" and "&IntegerToArabic(100*MOD(A1,1)) &" Halala", SIGN(MOD(A1,1))

  6. #6
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Converting Decimal number into Arabic Text

    See here an simular question.

    The used macro is showing below.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  7. #7
    Registered User
    Join Date
    12-25-2013
    Location
    madurai
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: Converting Decimal number into Arabic Text

    Dear Experts,

    Please help me.

    I would like to have convert dollar amount in to the following word format:

    $789,645.00 Seven Hundred Eighty Nine Thousand Six Hundred Forty Five Dollars and Point Zero Zero
    $758,465.90 Seven Hundred Fifty Eight Thousand Four Hundred Sixty Five Dollars and Point Nine Zero Cents
    $789,642.08 Seven Hundred Eighty Nine Thousand Six Hundred Forty Two Dollars and PointZero Eight Cents

    Your help will be highly appreciated.
    Thanks,
    Karthikeyan

  8. #8
    Registered User
    Join Date
    03-02-2016
    Location
    Saudi Arabia
    MS-Off Ver
    Office 2013 x32
    Posts
    1

    Re: Converting Decimal number into Arabic Text (In Saudi Riyals & Halalas)

    Hi Guys,

    Before i am facing same problem but now i solve this problem. here you guys find an attached file with macro & formulas. This file is ready for use.

    Just download file and enjoy it.


    Thanks,

    Tassawar Iqbal

  9. #9
    Registered User
    Join Date
    07-22-2018
    Location
    Saudi Arabia
    MS-Off Ver
    2016
    Posts
    4

    Re: Converting Decimal number into Arabic Text

    Why do the halala dont appear in my excel after entering the formula the result is
    765,961.88
    سبعمائة وخمسة وستون الفاً وتسعمائة وواحد وستون ريال و
    I also tried in another cell the missing component but It appears blank. When i removed the ISError the result is #VALUE.
    Any suggestion?

  10. #10
    Registered User
    Join Date
    07-22-2018
    Location
    Saudi Arabia
    MS-Off Ver
    2016
    Posts
    4

    Re: Converting Decimal number into Arabic Text

    I have downloaded the file and copied the VBA to my excel but the decimal is still hidden. I have checked everything including formats of cell but still I cannot solve the issue.

  11. #11
    Registered User
    Join Date
    10-11-2012
    Location
    united arab emirates
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: Converting Decimal number into Arabic Text

    Thanks a lot

  12. #12
    Registered User
    Join Date
    02-15-2020
    Location
    RIYADH
    MS-Off Ver
    7
    Posts
    1

    Re: Converting Decimal number into Arabic Text

    Hello, Text blurr. pls give solution. thnks
    فقط ستة وثمانون ريال وخمسة وثلاثون هلالة لا غير

  13. #13
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Converting Decimal number into Arabic Text

    Administrative Note:

    Welcome to the forum.

    We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

    Please see Forum Rule #4 about hijacking and start a new thread for your query.

    If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. #VALUE when converting Time to whole number and decimal
    By stoey in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-10-2013, 10:29 AM
  2. Replies: 3
    Last Post: 03-18-2006, 02:25 PM
  3. [SOLVED] Convert arabic number to english text
    By TSK in forum Excel General
    Replies: 2
    Last Post: 07-09-2005, 06:05 AM
  4. Converting a number to 2 decimal places
    By mattslav in forum Excel General
    Replies: 2
    Last Post: 06-03-2005, 11:10 PM
  5. [SOLVED] converting an arabic number into a spellout text
    By Widodo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-18-2005, 09:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1