Formatting text and numeric values

Text and numeric data can be formatted to make your charts and tables more presentable. Specifically:

• Text can be capitalized or converted to lower- or upper-case
• Text can be truncated after a certain number of characters or words
• Numbers can display a minimum or maximum number of decimal digits
• Numbers can omit the thousands separator
• Numbers can be formatted as:
  • Currency
  • Durations (seconds, minutes, hours, days, and weeks)
  • File sizes (bytes, kilobytes, megabytes, gigabytes, and terabytes)
  • Percentages
  • Scientific notation

To format a column’s text or numeric values:

1. Select the column (or columns) you wish to format:
   • In the Raw Data view, command-click a column header; or
   • In the Summary view, select one or more columns
2. Choose View > Show Formatting Options
3. Use the controls to make the desired changes

Note that descriptive statistics, such as means, have their own formatting options which can be configured in the application’s Preferences window.

See also:

• Formatting descriptive and inferential statistics
• Assigning colors to a table’s labels
• About the Summary view

---

Back to Wizard Help