Formats for Currency, Dates, Times, Names, and Phone Numbers

To find out what date/time format your Locale setting uses:

• From your personal settings, enter Advanced User Details in the Quick Find box, then select Advanced User Details. No results? Enter Personal Information in the Quick Find box, then select Personal Information.
• View the date/time format used in the read-only Created By field. This is the format you should use for entering dates and times in Salesforce fields.

Currency

In most Salesforce editions, the format and currency type you can use for currency fields, such as Quota or Annual Revenue, are determined by the Currency Locale setting for your company. In Group, Professional, Enterprise, Unlimited, and Performance Edition orgs that use multiple currencies, the format and currency type are determined by the Currency field in the record you’re creating or editing.

Tip In Salesforce Classic, when you enter a monetary amount (or any other type of number), you can use the shortcuts k, m, or b to indicate thousands, millions, or billions. For example, when you enter 50k it appears as 50,000. Uppercase shortcuts are also supported. In Lightning Experience, you can use the same shortcuts, in addition to t to indicate trillions. However, these shortcuts do not work for filter criteria.

Dates and Times

Many fields allow you to enter a date or a time in the format specified by your personal Locale setting.

When entering dates, you can choose a date from the calendar, or manually enter a date.

Only dates within a certain range are valid. The earliest valid date is 1700-01-01T00:00:00Z GMT, or just after midnight on January 1, 1700. The latest valid date is 4000-12-31T00:00:00Z GMT, or just after midnight on December 31, 4000. These values are offset by your time zone. For example, in the Pacific time zone, the earliest valid date is 1699-12-31T16:00:00, or 4:00 PM on December 31, 1699.

Tip

Consider the following shortcuts in Salesforce Classic.

• Years appear and are saved as four digits, but you can enter the final two digits and Salesforce determines the first two. Entries 60 through 99 are assumed to be in the 20th century (for example: 1964), and entries 00 to 59 are assumed to be in the 21st century (for example: 2012).
• If your locale is set to English (United States) and you enter numbers for month and day only (example: 01/15), Salesforce supplies the current year.
• If your locale and language are English, you can enter words like Yesterday, Today, and Tomorrow, or any day of the week, and Salesforce figures it out. Weekday names (such as Monday) are always considered to be in the following week.

Phone Numbers

When you enter phone numbers in various phone fields, Salesforce preserves whatever phone number format you enter. However, if your Locale is set to English (United States) or English (Canada), 10-digit phone numbers and 11-digit numbers that start with “1” are formatted as (800) 555-1212 when you save the record.

Tip

• If you do not want the parentheses-space-hyphen formatting ((800) 555-1212) for a 10- or 11-digit number, enter a “+” before the number. For example: +49 8178 94 07-0.
• If your 10- and 11-digit phone numbers have Salesforce’s automatic format, you might need to enter the parentheses when specifying filter conditions. For example: Phone starts with (415).