Home > Common Problem > How to automatically generate uppercase amounts in wps

How to automatically generate uppercase amounts in wps

藏色散人
Release: 2023-01-13 00:35:44
Original
24392 people have browsed it

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!

Related labels:
wps
source:php.cn
Statement of this Website
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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template