APPLICATION DESIGN
Displaying numbers in columns
To format values that result in a number displaying in the column, select a style in the Number tab of the Column Properties box.
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.
See Also
Adding programming to columns
Setting styles for a standard view or folder
Generating column totals, averages, and percents
Formatting date and time columns
Glossary
Feedback on Help?
Help on Help
Open Full Help Window
Glossary
Feedback on Help?
Help on Help
Open Full Help Window