Home  >  Article  >  How to automatically generate uppercase amounts in wps

How to automatically generate uppercase amounts in wps

藏色散人
藏色散人Original
2021-04-25 15:04:3824285browse

How wps automatically generates uppercase amounts: first open a new wps table; then enter the amount number in the cell of table B2; then click on the cell B2 where the number is entered, and right-click with the mouse; Finally, select [Special] in the [Number] category in [Cell Format] and click [RMB Capitalization].

How to automatically generate uppercase amounts in wps

The operating environment of this article: windows7 system, WPS Office2019 version, Dell G3 computer.

We first open a new wps table and select cell A1. Place the mouse directly on cell A1.

How to automatically generate uppercase amounts in wps

Enter the amount number in the cell of table B2.

How to automatically generate uppercase amounts in wps

Click on cell B2 where the number is entered, and then right-click with the mouse [Set cell format]

How to automatically generate uppercase amounts in wps

Select [Special] in the [Number] category in [Cell Format], you can see examples and types

How to automatically generate uppercase amounts in wps

After clicking the [Special] category, in the type Click [RMB Capitalization] here, click [OK]

How to automatically generate uppercase amounts in wps

After clicking OK, return to cell C2 and directly enter the number in the formatted cell. Effect

How to automatically generate uppercase amounts in wps

For more related knowledge, please visit the FAQ column!

The above is the detailed content of How to automatically generate uppercase amounts in wps. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn