Overview for Format Column

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.

Where to find this command

To format a column, click in the column, right-click, and choose Format Column.