Subscribe

English, French - Edit

The pattern must contain at least one digit symbol [#], [,] must be used as the grouping separator and [.] must be used as the decimal separator. The positive pattern is given first, followed by a separator symbol [;], the an optional negative pattern. If the negative pattern is not given, [-] will be used as a prefix for negative numbers.

All characters are translated literally, except for the following symbols:

Symbol Meaning
0 Digit
# Digit, zero shows as absent
. Decimal separator or monetary decimal separator
- Minus sign
, Grouping separator
;Separates positive and negative subpatterns
' Used 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".

Any character which is not a symbol can be defined as the "Number grouping separator" or "Number decimal separator"

The time format pattern must contain symbols for the "hour in day" and "minute in hour". The relevant symbols are:

Symbol Meaning Examples
HHour in day (0-23) 0
k Hour in day (1-24) 24
K Hour in am/pm (0-11) 0
h Hour in am/pm (1-12) 12
m Minute in hour 30
a Am/pm markerPM

The short date format pattern must contain symbols for the "day in month", month and year. This pattern is used for data input and as well as for displaying the date. If it does not have numeric forms of the "day in month", month and year, as well as uniform grouping separators, the system will attempt to use a data input format according to the languages and countries defined in your profile.

The symbols that can be used (for both the long and short date formats) are:

Symbol Meaning Examples
G Era designator AD
y Year 1996; 96
M Month in year July; Jul; 07
w Week in year 27
W Week in month 2
D Day in year 189
d Day in month10
F Day of week in month 2
E Day in week Tuesday; Tue
Pattern must contain the following symbols: [Y] and ([M] or [w] or [W]) and ([D] or [d] or [F] or [E])