WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free Download

Windows • MacOS • Linux • iOS • Android

banner

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

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?

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.