Translates a number into English Language text.
NUM2TXT(number, frac, places, dollar_txt, cent_txt, output_case, smart_case)
number is the number to be translated into English. It can be either a positive or a negative number; with/without decimal places. It may also be in scientific format, e.g. 234E+17
frac is a number either 1, 2, or 3. It determines the way decimal places (, if any,) are being treated. Default value is 1. (Optional)
Set frac equals to If decimal places exist 1 or omitted Translated into a fraction. e.g. 0.27 = 27/100 ; 0.12345 = 12345/100000 2 Translated into English words. e.g. 0.27 = zero point two seven 3 Completely ignore any decimal places. e.g. 1.6 = one
place determines how many decimal places (,if any,) to which you want to round number. (Optional)
dollar_txt is the text string to be placed before the decimal places. (Optional) For example, when translating the number 123,
dollar_txt Translation output Dollar One-Hundred Twenty-Three Dollar Pound One-Hundred Twenty-Three Pound
cent_txt is the text string to be placed after the decimal places. (Optional)
For example, when translating the number 123.25,
dollar_txt cent_txt Translation ouput Dollar Cent One-Hundred Twenty-Three Dollar Twenty-Five Cent Pound Pence One-Hundred Twenty-Three Pound Twenty-Five Pence
output_case is a number either 1, 2 or 3. It determines whether the output text string is in upper, lower, or proper case. Default value is 1. (Optional)
Set output_case equals to Effect 1 or omitted Output text in UPPER case 2 Output text in lower case 3 Output text in Proper case
smart_case is a Boolean value either TRUE or FALSE. It determines whether the word AND should always be in lower case. Default value is FALSE. (Optional)
Set smart_case equals to Effect TRUE The word and always in lower case FALSE or omitted The word and follows the value of the variable output_case.
NUM2TXT translation employs the following definitions :