How to apply accounting number format in WPS Spreadsheet

Uploaded time: November 24, 2021 Difficulty: Primary

How to apply accounting number format in WPS Spreadsheet

How to apply accounting number format in WPS Spreadsheet

Tips: After starting to play, you can adjust the video clarity, click

Quality

Auto 720p

Graphic skills

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?