Change the numbering formats for cell ranges.
* Cell range I7:J7
Accounting
5 decimal places
$ English (United States)
* Cell range I8:J8
¥ Japanese
Use the following steps in explanation.
Step 1:Click cell I7, Shift-click cell J7, right-click in this area, and from the context menu select Format Cells.
Step 2:In the Format Cells dialog box select Category Accounting, change Decimal places to: 5, and click OK.
Step 3:Click cell I8, shift-click cell J8,right-click in this area, and from the context menu select Format Cells.
Step 4:In the Format Cells dialog box select Category Accounting, change Decimal places to: 5, set Symbol to: ¥ Japanese, and click OK.
Result will be like:
