Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Edit directly in cell Excel User tips
  • Custom fiscal year calendar (CFlex) Basic Math
  • Zipcode-State search Formulas - combined functions
  • Get 3rd Wednesday of month Basic Math
  • Excel Limits Excel User tips
  • SimpleANBox Basic Math
  • VLookup Lookup and References
  • Validation based on another Validation COUNTA

UDF – Convert Number into text (English and Arabic)

Posted on January 31, 2012 By ANmar No Comments on UDF – Convert Number into text (English and Arabic)

Convert Numbers into English text and the final version of the Excel function to convert numeric values to Arabic text, (as 500 to خمسمائة). It will also enables you to add the unit you want. this was really hard in Arabic language.

UDF means User-Defined-Function, which means you need to enable macros

Use the English as:

=SpellNumber(400)

And Arabic as:

=Num2ArText(400)

 

Check the Web-based API here

 

User-Defined f(x)s = UDF

Post navigation

Previous Post: Progress bar in pure functions
Next Post: Change Calculator – calculate change in multiple bills/coins

Related Posts

  • WorksheetName and WorksheetsNo UDFs Lookup and References
  • Hyperlink usage and HyperlinkOf UDF CELL

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Recent Posts

  • Stale values (Scratched functions)
  • Middle name + 1st name
  • LastSunday, LastSaturday
  • Paste Special Percentage
  • Jan8 date format

Archives

Categories

  • Array formula (1)
  • Formulas – combined functions (58)
  • Google Sheets (2)
  • Non-functions (36)
    • ActiveX controls (2)
    • Conditional Formatting (7)
    • Data Validation (7)
    • Excel User tips (19)
    • Format Cells (6)
    • Graphics (4)
    • Names (3)
  • Standard functions (82)
    • Basic Math (18)
    • Date and Time (16)
      • DATE (9)
      • Hour (1)
      • MONTH (7)
      • NETWORKDAYS (2)
      • TODAY (7)
      • WEEKDAY (8)
      • WEEKNUM (1)
      • YEAR (8)
    • Engineering (1)
      • CONVERT (1)
    • Information (6)
      • CELL (4)
      • ISERROR (1)
      • N (1)
    • Logical (30)
      • AND (5)
      • IF (24)
      • IFERROR (6)
      • IFNA (1)
      • IFS (1)
      • ISERROR (1)
      • OR (2)
    • Lookup and References (36)
      • ADDRESS (4)
      • CHOOSE (3)
      • COLUMN (7)
      • FORMULATEXT (1)
      • HLOOKUP (1)
      • HYPERLINK (2)
      • INDEX (5)
      • INDIRECT (6)
      • MATCH (12)
      • OFFSET (15)
      • ROW (11)
      • VLOOKUP (5)
    • Math and Trig (24)
      • ABS (1)
      • CEILING (1)
      • COUNT (1)
      • COUNTA (4)
      • INT (9)
      • LARGE (2)
      • MAX (1)
      • Min (2)
      • SMALL (3)
      • SUM (3)
      • SUMIF (1)
      • SUMIFS (2)
      • SUMPRODUCT (1)
    • Statistical (5)
      • COUNTIF (4)
      • COUNTIFS (1)
    • Texts and Strings (24)
      • CHAR (5)
      • CONCATINATE (1)
      • FIND (1)
      • LEFT (8)
      • Len (4)
      • MID (9)
      • REPT (3)
      • RIGHT (2)
      • SEARCH (9)
      • STRING (1)
      • SUBSTITUTE (2)
      • TEXT (4)
      • TRIM (2)
      • VALUE (2)
  • Uncategorized (2)
  • User-Defined f(x)s = UDF (3)
    • HyperlinkOf (1)
  • Worksheet (16)
  • XLfxs (2)

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
  • Sort list dynamically (functions) COLUMN
  • Get column name (columnname as A,B,C, etc) as input inside cell ADDRESS
  • Searching table in 2 dimensions. Formulas - combined functions
  • Tally chart in functions Formulas - combined functions
  • Workdays – Across months DATE
  • 6174 Kaprekar’s constant Basic Math
  • Why I ran from =INDIRECT() function Formulas - combined functions
  • Filter. Google Sheets function Google Sheets

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme