To make an effective digital reserves required digit which function
Beg god for help
CodePudding user response:
Try the format function...CodePudding user response:
User-defined numeric expression format example
The following table contains some examples of numerical expression format, (all these examples assume system the country is set to English - U.S.) of the first column contains format string, the other columns for the output, suppose format data have given value in the list head,
Format (Format) is 5 minus 5 decimal. 5 Null
Zero-length string (" "), 5-0.5
0 5-1
0.00 5.00 5.00 0.50
#, # # 0 5-1
#, # # 0.00;;; 5.00 5.00 0.50 Nil Nil
$#, # # 0; ($#, # # 0) $5 ($5) $1
$#, # # 0.00; ($#, # # 0.00) at $5.00 ($5.00) $0.50
0% 500% 500% 50%
0.00% 500.00% 500.00% 50.00%
0.00 e+00 e+00 5.00-5.00 e+00 5.00 e-01
0.00 e-00 e00 5.00-5.00 e00 5.00 e-01
User-defined numeric Format (the Format function)
The following table identifies the number of characters can be used to create user-defined numeric format:
Character description
No display no numerical format,
Digital placeholders (0), according to a number or zero, if the expression in the format string 0 there are a number of position, then display; Otherwise, it displayed in a zero, if numerical digits is less than the format expression of zero digits (either left or right) side of the decimal point, then put up front or the back of the zero, if the decimal point to the right numerical digits than in decimal format expression right zero digits, then the last of the rounded to zero digits, if the value of the decimal point left digits than in decimal format expression left zero digits, so much a part of or unscripted display,
(#) digital placeholder, display a number or nothing, if the expression in the format string figures are the location of the "#", then display; Otherwise, the position is what all don't, according to
The working principle of the symbol and "0" digital placeholder is roughly same, the difference only in when expressions numerical digits is less than the "#" digits (decimal point to the left or right), won't put in front of or behind the zero displayed,
Decimal point (.) a placeholder, and in some country is when the decimal point with a comma, decimal placeholders used to determine the decimal point about how many digits can be shown, if the expression format only sign in the symbol on the left, then a number will begin with decimal point for less than 1, if want to have a "0" in front of the decimal Numbers, then please in front of the decimal point placeholder plus the number "0" placeholder, decimal placeholder actual characters in format depends on the output of the system of the digital format,
Percentage (%) sign a placeholder, expression multiplied by 100, the percentage of character (%) will be inserted into a position in the format string,
(,) micrometer a placeholder symbols, in some country, is to use a period to be one thousand symbols, one thousand symbols are mainly the numerical decimal point on the left more than one thousand, more than four digits separated if format in digital placeholders (0 or #) contains a micrometer around a symbol, is designated as the micrometer is a standard notation to use, two adjacent micrometer symbol or a micrometer level symbol immediately to the left of the decimal point (regardless of whether or not specified decimal places), its meaning is "the numerical divided by 1000, according to the need to round up", for example, you can use the format string "# # 0," will says 100 million to 100, the value is less than 1 million words as "0", the two adjacent micrometer symbols in addition to following the decimal point on the left, in the presence of any position are simply used as the specified micrometer symbols, decimal placeholder real characters in the output format will be subject to the digital format of system identification,
(:) time delimiter, in some country, may use other symbols to be delimiter, time when formatting time value, time separators can be used to separate, minutes and seconds, the time of the separator real characters in the output format depends on the system Settings,
Date (/) delimiter, in some country, may be when the date separator, with other symbols in the formatted date value, date separator can be used to separate year, month, day, date separator real characters in the output format, depending on the system Settings,
(E - E + E - E +) scientific format, if the format expression in E - E +, E - or right of the E + containing at least one digital placeholders (0 or #), then the numerical format will be represented as science, and E or E will be placed between the index and Numbers, the number of E or E to the right digital placeholder depends on index digits, using E - or E - with a minus sign to indicate a negative, have been using a + E and E +, will use a minus sign to indicate a negative have been represented by a plus sign is been found,
- + $() to display a literal characters, if want to display the list of characters of characters, you can use the backslash (\) character as a prefix or enclosed in double quotation marks (" "),
The next character (\) format string displayed, if you want to show character and has a special meaning as the original meaning of characters, the characters can be placed in a backslash (\), after the backslash itself will not be displayed, and use the backslash (\) and the effect of using double quotes is the same, if you want to display the backslash character, can use two backslashes (\ \),
Those who can't show for literal characters character is a date format characters and time format characters (a, c, d, h, m, n, p, q, s, t, w, y and/or:), the numerical format characters (#, 0, %, E, E, commas and periods) and string format character (@, & amp; , & lt; , & gt; And!) ,
(" ABC ") shows the double quotes (" ") within a string, such as in the code to contain a string in the format, must use CRH (34) the text enclosed (34 for double quotation marks (") character code),