When creating or editing a custom locale, you can customize how number, dates, and times appear for the locale inside the Numbers and Dates and Times tabs.
Numbers
The following table indicates numbers you can customize for a custom locale.
|
Item
|
Description
|
|---|
|
Digital Grouping
|
Controls the appearance of how digits are separated
|
|
Decimal Separator
|
Controls whether digits are separated using a comma or a period
|
|
Group Separator
|
Controls the appearance of how groups are separated
|
|
Negative Symbol
|
Controls how the negative symbol appears
|
|
Negative Format
|
Controls how negative numbers display
|
Percentages
The following table indicates percentages you can customize for a custom locale.
|
Item
|
Description
|
|---|
|
Percent Format
|
Controls how numbers with accompanying percentage signs display
|
|
Negative Percent Format
|
Controls how negative numbers with accompanying percentage signs display
|
Calendar Settings
The following table indicates calendar settings you can customize for a custom locale.
|
Item
|
Description
|
|---|
|
Calendar
|
Controls which calendar format to use
|
|
First Day of the Week
|
Controls which day of the week is considered the first day of the week
|
|
Weekends
|
Controls which days of the week are considered the first and last days of the weekend
|
Date Formats
The following table indicates date formats you can customize for a custom locale.
|
Item
|
Description
|
|---|
|
Short Date Format
|
Controls in which order day, month, and year appear in a short date format
|
|
Standard Date Format
|
Controls in which order day, month, and year appear in a standard date format
|
|
Long Date Format
|
Controls in which order day, month, and year appear in a long date format
|
|
Month and Day Format
|
Controls in which order day and month appear in a month and day format
|
|
Month and Year Format
|
Controls in which order month and year appear in a month and year format
|
|
Time Format
|
Controls how hours and minutes appear, as well as if AM or PM signifiers display
|