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_txtTranslation outputDollar 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_txtcent_txtTranslation ouputDollar 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 toEffect1 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 toEffectTRUE The word and always in lower case FALSE or omitted The word and follows the value of the variable output_case.

- Absolute value
of the number input must be smaller than one thousand nonillion. (US English
definition : 10
^{33}) (i.e. -1E+33<x<1E+33) - Under Excel 5 and 7, length of translation output must not exceed 255 characters, which is the maximum length a cell can accommodate. Under Excel 8 (Excel 97), length of translation output must not exceed 32,000 characters
- The language translation adopts the US English convention.

NUM2TXT translation employs the following definitions :

- one billion = one thousand million = 1E+9
- one trillion = one thousand billion = 1E+12
- one quadrillion = one thousand trillion = 1E+15
- one quintillion = 1E+18
- one sextillion = 1E+21
- one septillion = 1E+24
- one octillion = 1E+27
- one nonillion = 1E+30