NUM2TXT

Translates a number into English Language text.

Syntax

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.

Limitations

  1. Absolute value of the number input must be smaller than one thousand nonillion. (US English definition : 1033) (i.e. -1E+33<x<1E+33)
  2. 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
  3. The language translation adopts the US English convention.

Remarks

NUM2TXT translation employs the following definitions :