{"id":143,"date":"2012-01-31T08:36:54","date_gmt":"2012-01-31T14:36:54","guid":{"rendered":"http:\/\/xlfxs.com\/?p=143"},"modified":"2012-01-31T08:36:54","modified_gmt":"2012-01-31T14:36:54","slug":"udf-convert-number-into-text-english-and-arabic","status":"publish","type":"post","link":"https:\/\/xlfxs.com\/?p=143","title":{"rendered":"UDF &#8211; Convert Number into text (English and Arabic)"},"content":{"rendered":"<p><span style=\"font-size: small;\">Convert Numbers into English text and the final version of the Excel function to convert numeric values to Arabic text, (as 500 to \u062e\u0645\u0633\u0645\u0627\u0626\u0629). It will also enables you to add the unit you want. this was really hard in Arabic language.<\/span><\/p>\n<p><span style=\"font-size: small;\">UDF means User-Defined-Function, which means you need to enable macros<br \/>\n<\/span><\/p>\n<p>Use the English as:<\/p>\n<pre>=SpellNumber(400)<\/pre>\n<p>And Arabic as:<\/p>\n<pre>=Num2ArText(400)<\/pre>\n<p>&nbsp;<\/p>\n<p><a class=\"btn btn-lg btn-primary\" href=\"http:\/\/anmarsystems.com\/Product\/?ID=77391\" target=\"_blank\" rel=\"noopener\">Check the Web-based API here<\/a><\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2012\/02\/Num2Text.zip\"><img decoding=\"async\" class=\"aligncenter\" src=\"\/wp-content\/uploads\/2014\/12\/Download1.png\" alt=\"\" \/><\/a><\/p>\n\n","protected":false},"excerpt":{"rendered":"<p>Convert Numbers into English text and the final version of the Excel function to convert numeric values to Arabic text, (as 500 to \u062e\u0645\u0633\u0645\u0627\u0626\u0629). 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&#8230;<\/p>\n<p class=\"more-link-wrap\"><a href=\"https:\/\/xlfxs.com\/?p=143\" class=\"more-link\">Read More<span class=\"screen-reader-text\"> &ldquo;UDF &#8211; Convert Number into text (English and Arabic)&rdquo;<\/span> &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":150,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[],"class_list":["post-143","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-udf-user-defined-functions"],"_links":{"self":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/143","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=143"}],"version-history":[{"count":0,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/143\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/media\/150"}],"wp:attachment":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=143"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=143"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=143"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}