numberFormat
Returns a string version of the number argument, formatted as specified by the pattern string. This is commonly used to specify the number of decimal places to display, but can be used for more advanced formatting as well. The pattern string is a numeric format string, which may include any of these characters that instruct it how to format the number.
Symbol |
Description |
0 |
Specifies a required digit |
# |
Specifies an optional digit |
, |
The grouping separator |
. |
The decimal separator |
- |
A minus sign |
E |
Scientific notation |
; |
Used to separate positive and negative patterns |
% |
Multiplies the value by 100 and shows as a percent |
' |
Used to quote special characters |
This table shows some numbers, and the result of using various format strings to format them.
Number |
Pattern |
Result |
5 |
0 |
5 |
5 |
0.0 |
5.0 |
5 |
00.0 |
05.0 |
123 |
#,##0 |
123 |
1024 |
#,##0 |
1,024 |
1337 |
#,##0.# |
1,337 |
1337.57 |
#,##0.# |
1,337.6 |
87.32 |
#,##0.0000 |
87.3200 |
-1234 |
#,##0 |
-1,234 |
-1234 |
#,##0;(#,##0) |
(1,234) |
4096 |
0.###E0 |
4.096E3 |
.348 |
#.00% |
34.80% |
34.8 |
#0.00'%' |
34.80% |
numberFormat( number, pattern )
numberFormat(
34.8
,
"#0.00'%'"
)
//returns the string "34.80%"