How to apply accounting number format in WPS Spreadsheet

Uploaded time: November 24, 2021 Difficulty Beginner

A free Office suite fully compatible with Microsoft Office

Free Download

How to apply accounting number format in WPS Spreadsheet

How to apply accounting number format in WPS Spreadsheet

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+1is also available.


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.


Did you get it?