text format string - date and time patterns - numbers
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
Still loading...
ABCDEFGHIJKLMNOPQRST
1
SymbolLocationLocalized?Meaning1234.567-1234.567Notes:123456789Slightly adapted info from:http://java.sun.com/j2se/1.4.2/docs/api/java/text/DecimalFormat.htmlAlso look at:http://javaalmanac.com/egs/java.text/FormatNumExp.html?l=rel
2
0NumberYesDigit1235-1235
3
#NumberYesDigit, zero shows as absent1235-1235
4
.NumberYesDecimal separator or monetary decimal separator1234.5670-1234.567
5
-NumberYesMinus sign-1234.5670--1234.567not working123,456,789.012345
6
,NumberYesGrouping separator1,234.5670-1,234.567123,456,789.012345
7
ENumberYesSeparates mantissa and exponent in scientific notation. Need not be quoted in prefix or suffix.#VALUE!-1.2345670E03
8
;Subpattern boundaryYesSeparates positive and negative subpatterns+1234.567-1234.567another example: 1234.567 (1234.567)
9
%Prefix or suffixYesMultiply by 100 and show as percentage123457%-%123457
10
‰ \u2030Prefix or suffixYesMultiply by 1000 and show as per mille1235‰‰1235working now
11
¤ (\u00A4)Prefix or suffixNoCurrency sign, replaced by currency symbol. If doubled, replaced by international currency symbol. If present in a pattern, the monetary decimal separator is used instead of the decimal separator.¤ 1234.57¤¤ 1234.57?1234.56¤7
12
'Prefix or suffixNoUsed to quote special characters in a prefix or suffix, for example, "'#'#" formats 123 to "#123". To create a single quote itself, use two in a row: "# o''clock".''1234.567-''1234.567
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
 
 
 
Numbers
Date and Time