Example of Format Column

A bank administrator collects data from loan applicants. The administrator wants to add currency symbols to the columns that contain monetary data.

  1. Open the sample data, LoanApplicant.MTW.
  2. Click in the Income column and choose Editor > Format Column.
  3. From Choose type, select Currency.
  4. Click OK.
  5. Select the Savings and Debt columns and choose Editor > Format Column.
  6. From Choose type, select Currency.
  7. Click OK.

Results

Income, Savings, and Debt are formatted as currency.

C1 C2 C3 C4 C5 C6 C7 C8
Income Education Age Residence Employ Savings Debt Credit Cards
$50,000 16 28 2 2 $5,000 $1,200 2
$72,000 18 35 10 8 $12,000 $5,400 4
$61,000 18 36 6 5 $15,000 $1,000 2
$88,000 20 35 4 4 $980 $1,100 4
... ... ... ... ... ... ... ...
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy