The Numeric Format Editor dialog has the following options:
- Number: select this item to format values as numbers.
- Decimals: this specifies the number of decimal places to display.
- Fixed: turn this setting on to always display the number of decimals indicated; turn it off to not display trailing zeros.
- Thousands: turn this setting on to display the thousands separator.
- Percent: turn this setting on to display the percent sign (%).
- Currency: turn this setting on to display the currency symbol.
- Date Time: turn this setting on to format values as date and time values. You can select the desired format from the drop-down list beside this setting.
- Geographic: turn this setting on to format values as latitude and longitude values. You can select the desired format from the drop-down list beside this setting.
- Custom: if you want to use a custom format, type the format into this setting. Use "#" as a digit placeholder, "," as a placeholder for the thousands separator, "." as a placeholder for the decimals separator, and "0" to display a zero in that place.