Concept: Locale, Language, and Time Zone in Workbooks
Worksheets uses a combination of the settings in your Workday user profile, along with workbook-specific settings, to determine how to display information.
If you're the workbook owner or you have edit permissions, you can change the locale or language of an open workbook in the menu. To change the time zone, you must be the workbook owner. Worksheets supports only the values listed in the drop-down menu.
If the current workbook locale, language, or time zone doesn't match your profile setting, a globe icon displays to the right of the menu bar; hover over or click the globe icon to see the settings.
Keep in mind that when someone puts a value into a cell, it will stay in that same language. If other users with different language settings view the cell, they will see the value in the language that it had when it was originally entered in the cell.
This table summarizes the settings and which values they affect:
Setting | Effects |
|---|---|
Workday Settings: User Profile Display Language User Profile Locale User's Time Zone | Language, locale formatting, and time zone of elements external to the values in the cells of the workbook. Examples: Text and values in menu items, dialogs, and side panels. |
Language | Language of user interface elements related to the values in the cells of the workbook. Examples:
|
Locale | Formatting of values in the cells within the workbook. Examples:
|
Time Zone | Time zone of the workbook, which can affect data such as live data values, or results for certain functions such as NOW(), which returns the current date and time. |