Shulou(Shulou.com)06/02 Report--

This article mainly introduces "what is the return expression of formatnumber function". In daily operation, I believe that many people have doubts about what the return expression of formatnumber function is. Xiaobian consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubt of "what is the return expression of formatnumber function?" Next, please follow the editor to study!

FormatNumber (

Expression [, NumDigitsAfterDecimal [, IncludeLeadingDigit [, UseParensForNegativeNumbers [, GroupDigits]

)

Arguments

Expression

Required. The expression to be formatted.

NumDigitsAfterDecimal

Optional. Indicates the number of digits displayed to the right of the decimal point. The default value is-1, indicating that the computer's locale is being used.

What is the expression returned by the formatnumber function

IncludeLeadingDigit

Optional. A three-state constant indicating whether the zero before the decimal point is displayed. For numerical values, see the Settings section.

UseParensForNegativeNumbers

Optional. A three-state constant indicating whether a negative value is placed in parentheses. For numerical values, see the Settings section.

GroupDigits

Optional. A three-state constant indicating whether digits are grouped using the numeric grouping symbols specified in the computer locale. For numerical values, see the Settings section.

Set (three-state constant)

The IncludeLeadingDigit, UseParensForNegativeNumbers, and GroupDigits parameters can have the following values:

Constant value description

TristateTrue-1True (use)

TristateFalse0False (not used)

TristateUseDefault-2 uses the settings in the computer locale.

Description

When one or more optional parameters are omitted, the value of the omitted parameter is provided by the computer locale.

The following is an example:

Display result:. five

Display result: 0.5

At this point, the study of "what is the return expression of the formatnumber function" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.