NUMTO - Returning Number-Converted Chinese Texts

  • Last update:July 25, 2023
  • 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.

    • iconNote:
      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.

    NUMTO.png

    More examples:

    FormulaResultNotes
    NUMTO(2345,true)二三四五
    NUMTO(2345,false)二千三百四十五
    NUMTO(2345)二千三百四十五



    附件列表


    主题: Advanced Data Analyis
    Previous
    Next
    • Helpful
    • Not helpful
    • Only read

    滑鼠選中內容,快速回饋問題

    滑鼠選中存在疑惑的內容,即可快速回饋問題,我們將會跟進處理。

    不再提示

    10s後關閉

    Get
    Help
    Online Support
    Professional technical support is provided to quickly help you solve problems.
    Online support is available from 9:00-12:00 and 13:30-17:30 on weekdays.
    Page Feedback
    You can provide suggestions and feedback for the current web page.
    Pre-Sales Consultation
    Business Consultation
    Business: international@fanruan.com
    Support: support@fanruan.com
    Page Feedback
    *Problem Type
    Cannot be empty
    Problem Description
    0/1000
    Cannot be empty

    Submitted successfully

    Network busy