Send feedback on this help.| Format string | Value | Output |
|---|---|---|
|
##### |
123 |
123 |
|
00000 |
123 |
00123 |
|
(###) ### - #### |
1234567890 |
(123) 456 – 7890 |
|
#.## |
1.2 |
1.2 |
|
0.00 |
1.2 |
1.20 |
|
00.00 |
1.2 |
01.20 |
|
#,# |
1234567890 |
1,234,567,890 |
|
#,, |
1234567890 |
1235 |
|
#,,, |
1234567890 |
1 |
|
#,##0,, |
1234567890 |
1,235 |
|
#0.##% |
0.086 |
8.6% |
|
0.###E+0 |
86000 |
8.6E+4 |
|
0.###E+000 |
86000 |
8.6E+004 |
|
0.###E-000 |
86000 |
8.6E004 |
|
[##-##-##] |
123456 |
[12-34-56] |
|
##;(##) |
1234 |
1234 |
|
##;(##) |
-1234 |
(1234) |