Changing the cells to numeric fields

Now you must set Quantity, Unit Price, and Amount as numeric fields.

1. Select the first cell under Quantity.

   

2. In the Object palette, click the Cell tab and select Numeric Field in the Type list.

3. In the Cell tab, select None from the Appearance list.

4. Repeat steps 1 to 3 for Unit Price and Amount.

5. The Unit Price and Amount fields show currency. To format the data to show numbers as currency, drag to select the cells in the Unit Price and Amount columns. Then in the Object palette, click the Cell tab, click the Patterns button, and in the Pattern box, type $z,zz9.99.

6. Click OK.

Click to continue: Naming the fields

 Twitter™ and Facebook posts are not covered under the terms of Creative Commons.