How to apply accounting number format in WPS Spreadsheet

Uploaded time: November 24, 2021 Difficulty: Beginner

How to apply accounting number format in WPS Spreadsheet

How to apply accounting number format in WPS Spreadsheet

Tips: you can turn on the volume by clicking

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Counting the amount in areas of finance and accounting is quite necessary. Take this Budgetary sheet as an example. The table's currency symbols and decimal points are badly aligned, which is not convenient for us to consult and calculate. How can we improve it?

 

Select the cells D7-D15. Click Number Format in the Home tab, and select More Number Format in the drop-down list. Shortcut key Ctrl+1 is also available.

_1.gif


Then select Accounting in the dialog box, where we can set the decimal places, enter 2 in the edit box, and select the currency symbol we need at Symbol. Finally, click OK. In this way, the currency symbols and decimal points in the table can be aligned, and the table can be viewed more clearly.

_2.gif


Did you get it?