Overview
Grammar | NUMTO (number, bool) or NUMTO (number) | Returns number-converted Chinese texts. |
Parameter 1 | number | Number |
Parameter 2 | boolean | Determines how to display the Chinese text. If the NUMTO function contains no boolean value, the result is displayed in a default way. The default boolean value is false. |
Notes
The function supports two parameters. The first parameter is of the numeric type and the second is of the boolean type.
The "true (TRUE)" and "false (FALSE)" in the second parameter are case-insensitive.
Note:Direct connect data does not support the NUMTO function.
Example
If you want to convert the "Advertising fee" to Chinese text, such as converting "120000" to "十二万", you can enter the formula NUMTO(Advertising fee), as shown in the following figure.
| Formula | Result | Notes |
|---|---|---|
| NUMTO(2345,true) | 二三四五 | |
| NUMTO(2345,false) | 二千三百四十五 | |
| NUMTO(2345) | 二千三百四十五 |
Previous：PROPER - Converting Texts to Proper Letter Case
