The culture settings give administrators control over formats and symbols that vary amongst geographic location. These settings can be overwritten for a specific user or group of users by modifying the Role. For more information see Roles.
The following settings are available:
The format of date values. May be any .NET standard (e.g., MM/dd/yyyy).
The format of time values. May be any .NET standard (e.g., h:mm:ss tt).
The format of date-time values. May be any .NET standard (ex. M/d/yy h:mm tt).
Note: For more information on .NET Date, Time, and DateTime format strings please visit this article.
Choose to format DateTime as Date or DateTime values. To change this setting for specific columns see Column Metadata.
Note: Column metadata will override culture settings.
Symbol used to separate 3 digit groups (ex. thousandths) in numeric values. The default is a comma (,).
Symbol prepended to numeric values to represent currency. The default is the US currency symbol ($).
Symbol used for numeric decimal values. The default is a period (.).
Default number of decimal places for numeric fields to show. Leave blank to keep variable by field.
Default number of decimal places for currency fields to show. Leave blank to keep variable by field.
Set to true to apply the Numeric Decimal Places to any cell that has Cell Formatting set to General but contains a number. Default value is false.
Set to true to cause currency values to appear right-aligned by default in report cells.
A null-able decimal value that is used to convert server to client time (the negation is used to convert client to server time). This offset is not applied to data coming from Data Sources. It is utilized by Exago features like the Scheduling Service. Leave blank to use server time or if using an External Interface to calculate value.