176k views
1 vote
Apply the Accounting number format, using the dollar sign ($) and two decimal places, to a cell range (ex: C4:C15):

a. Highlight cells > Right-click on cells > Click on Format Cells > Click on Number, then choose Accounting > Make sure to choose 2 decimal places and dollar sign
b. Right-click on cells > Highlight cells > Click on Format Cells > Click on Number, then choose Accounting > Make sure to choose 2 decimal places and dollar sign
c. Click on Format Cells > Highlight cells > Right-click on cells > Click on Number, then choose Accounting > Make sure to choose 2 decimal places and dollar sign
d. Click on Number, then choose Accounting > Highlight cells > Right-click on cells > Make sure to choose 2 decimal places and dollar sign

User Afeldspar
by
7.6k points

1 Answer

6 votes

Final answer:

To apply the Accounting number format to a cell range in Excel, follow these steps: highlight the cells, right-click and choose Format Cells, select the Number tab, choose the Accounting format, and make sure to choose 2 decimal places and a dollar sign.

Step-by-step explanation:

  1. Highlight the cells in the range (ex: C4:C15)
  2. Right-click on the highlighted cells
  3. Click on Format Cells
  4. Select the Number tab
  5. Choose the Accounting format
  6. Click on OK
  7. Make sure to choose 2 decimal places and a dollar sign

User Christiandeange
by
8.2k points