Journal ID : TRKU-20-03-2020-10563
[This article belongs to Volume - 62, Issue - 03]
Total View : 173

Title : CREATE A NEW FUNCTION TO CONVERT NUMBERS INTO TEXT FORM BY MS-EXCEL IN THREE LANGUAGES (ENGLISH, KURDISH, AND ARABIC)

Abstract :

Excel actually becomes influential once you start using functions, which are mathematical formulas that assistance you rapidly and effortlessly make calculations that would be difficult to do by hand. Functions can do various things to speed up your calculations. Excel doesn’t have a default function that displays numbers as English, Kurdish or Arabic words in a worksheet, but you can add this capability by pasting the WrittenNumber function code into a VBA (Visual Basic for Applications) module. This function lets you convert numbers to words with a formula, so (22.50) would read as Twenty-Two Point Fifty. This can be very useful if you're using Excel as a template to print Student's marks/degrees. This study covers example Microsoft Visual Basic for Applications functions that you be able to usage to convert a numeric value in a MS-Excel Spreadsheet cell into its equal value in English, Kurdish or Arabic words. When you want to convert numbers in English, Kurdish or Arabic words; select a WrittenNumberEn, WrittenNumberKr, or WrittenNumberAr Function. It was expected that there would be many end-user program writers in various dissimilar fields like accounting, insurance and banking, and the numbers are not estimated to have diminished later. Therefore, technical improvements of spreadsheets are of unlimited attention to a varied number of persons from diverse experiences

Full article