When you select "Use preferences from User settings," the format for numbers depends on display settings for a computer's operating system. You can select a subset of display options to format number values in a column. When you select "Use preferences from Custom," you have more control over how numbers display.

• Decimal formatting displays numbers as they are entered; zeroes to the right of the decimal point are suppressed. For example, 6.00 displays as 6. You can specify a fixed number of decimal places to display (up to 15 places) or select varying to display a number as entered.
• Percent formatting displays numbers as a percentage. For example, .10 displays as 10%.
• Scientific formatting displays numbers using exponential notation; for example, 10,000 displays as 1.00E+04.
• Currency formatting displays values with a currency symbol and two digits after the decimal symbol; for example, $15.00. The currency symbol and thousands separator displayed are based by default on settings in your operating system. To override those settings, choose Custom in the "Preferences for display formatting" section. You can then specify formatting and display options such as a currency symbol and thousands separator.
• Select "Parentheses on negative numbers" to display negative numbers enclosed in parentheses; for example, display (5) instead of -5.
• Select "Punctuated at thousands" to display large numbers with the thousands separator; for example, 1,000 in English, or 1.000 in French.

Adding programming to columns
Setting styles for a standard view or folder
Generating column totals, averages, and percents
Formatting date and time columns
Enabling a column for instant messaging

Glossary

Help on Help

Open Full Help Window

Glossary

Help on Help