Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • IF with AND and IF with OR AND
  • Cuts string of list of items Formulas - combined functions
  • Hello world! Uncategorized
  • Skills Grid Conditional Formatting
  • Links between two workbooks – dynamically using functions INDIRECT
  • Blank (isempty) VS “” (null string) Excel User tips
  • Get monthly total from table with dates DATE
  • 6174 Kaprekar’s constant Basic Math

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

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

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
  • MATCH fumction, just a simple search Lookup and References
  • Get column name (columnname as A,B,C, etc) as input inside cell ADDRESS
  • Excel Functions = XL f(x)s XLfxs
  • Extract Address into table Formulas - combined functions
  • Looplist – Repeating months using formulas Basic Math
  • When Excel tells you to go get some life Excel User tips
  • Return 12 values in one number AND
  • Standard math to calculate Aspect Ratio Basic Math

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme