How to set excel accounting special format

How to set the accounting-specific format: first open the excel table, select the cells that need to be operated; then press the "ctrl 1" key on the keyboard to bring up the "Cell Format" window; finally select "Accounting "Private" and click "OK".

The operating environment of this tutorial: windows7 system, WPS Office2016 version, Dell G3 computer.

The steps to set the accounting-only type in Excel are:

Open Excel and select the cells you want to set to the accounting-only type;

Use the "ctrl 1" key on the keyboard to jump to the "Cell Format" setting window, select "Accounting Only", and click "OK".

You can see the effect of the set accounting special type.

This solves the problem of setting up special accounting in Excel.

Related learning recommendations: excel tutorial

The above is the detailed content of How to set excel accounting special format. For more information, please follow other related articles on the PHP Chinese website!