Specify Default Date and Number Formats With Regional Preferences

Smartsheet will display dates in the appropriate format for the地区性的偏好you've specified for your account.

你可以also apply formats to date columns in your sheet (for example, long format with the day and month spelled out). More information on this is available in Apply Formats to Date Columns.

For example, if地区性的偏好is set toEnglish (United States), dates will be displayed in the format month-day-year. If you've set Regional Preferences to English (United Kingdom), dates will be displayed in the format day-month-year.

To change the default date and number formats:

1. Click账户>Personal Settings,to display the Personal Settings window.
2. ClickSettingsin the left pane.
3. Under地区性的偏好,select the desired value from the dropdown list.
   
   The date and number formats for the selected preference will be displayed under the dropdown.
   
4. ClickSaveto apply the changes.

Dates and number formats in your sheets will be updated to match the new setting.