Format columns

Complete the following steps to format one or more columns.

In This Topic

Select the columns and open the dialog box
Select the format

Select the columns and open the dialog box

Select the column or columns to format. The columns must be adjacent and have the same data type.
Right-click the column and choose Format Column.

Select the format

From Choose type, select the format.

Automatic numeric

Minitab determines the number of decimal places to display, depending on the values in the column.

Fixed decimal

Display the numbers with a fixed number of decimal places. From Decimal places, select the number of decimal places to display.

Exponential

Display the numbers in exponential format. From Decimal places, select the number of decimal places to display before the E. For example, the number 3200 in exponential format is 3.20E+03 with two decimal places, or 3.2E+03 with one decimal place.

Currency

Display the numbers in a currency format. Do the following:

From Decimal places, select the number of decimal places to display.
From Symbol, select the currency symbol. The options that are available depend on the regional and language settings in the Windows Control Panel.
From Negative numbers, select the format to use for negative currency values.

Percentage

Display the numbers in a percentage format. From Decimal places, select the number of decimal places to display.

Date

Display the data in a date format. Select a format from the list, or enter a custom format. For more information, go to Date/time formats that Minitab recognizes, or Defining custom date/time display formats.

If you change text data to date/time data, the Convert Text to Date Time dialog box appears. Specify an existing date format to use, or enter a custom format.

Time

Display the data in a time format. Select a format from the list, or enter a custom format. For more information, go to Date/time formats that Minitab recognizes, or Defining custom date/time display formats.

If you change text data to date/time data, the Convert Text to Time dialog box appears. Specify an existing time format to use, or enter a custom format.

Elapsed time

Display the data in an elapsed time format. Select a format from the list, or enter a custom format. For more information, go to Date/time formats that Minitab recognizes, or Defining custom date/time display formats.

If you change text data to elapsed time data, the Convert Text to Elapsed Time dialog box appears. Specify an existing elapsed time format to use, or enter a custom format.

Text

Format the column as text data.