Notice
You are now leaving support.minitab.com.
Click Continue to proceed to:
Use Format Column to specify how a column of data is displayed in the worksheet. The following worksheet contains examples of different column display formats. C1–C5 are numeric formats, C6–C8 are date/time formats, and C9 is text format.
| C1 | C2 | C3 | C4 | C5 | C6-D | C7-D | C8-D | C9-T |
|---|---|---|---|---|---|---|---|---|
| Auto numeric | Fixed decimal | Exponential | Currency | Percentage | Date | Time | Elapsed time | Text |
| 68.00 | 68.0000 | 6.80E+01 | $68.00 | 6800.00% | 1/22/2016 | 4:22:38 am | 12:33:44 | Red |
| 63.43 | 63.4300 | 6.43E+01 | $63.43 | 6340.00% | 4/29/2016 | 5:02:25 am | 6:22:14 | Blue |
| 67.45 | 67.4500 | 6.75E+01 | $67.45 | 6745.00% | 8/9/2016 | 11:02:54 pm | 9:02:00 | Green |
| 0.12 | 0.1200 | 1.20E-01 | $0.12 | 12.00% | 10/4/2016 | 9:43:32 pm | 36:33:44 | Purple |
You can use Format Column to change the data type. For example, if you specify a numeric format for a text column, the text values are converted to numeric values. For more information, go to Minitab data types and formats.
To format a column, click in the column, right-click, and choose Format Column.
You are now leaving support.minitab.com.
Click Continue to proceed to: