Home > Topics > excel > body text

How to convert numbers into uppercase amounts

藏色散人
Release: 2020-05-15 09:58:29
Original
12068 people have browsed it

How to convert numbers into uppercase amounts

How to convert numbers into uppercase amounts

Numbers in Excel are automatically converted into uppercase amounts

Method 1: Open the Excel document, click to select the cell where you want to enter the uppercase amount, enter the number, and right-click on the cell.

Recommended: "Excel Tutorial"

How to convert numbers into uppercase amounts

Click "Format Cells", select "Special" in the category, and Select "RMB Capital" as the type and click "OK".

How to convert numbers into uppercase amounts

Method 2: Right-click on the cell, click "Format Cells", and select "Special" in the category.

How to convert numbers into uppercase amounts

Select "RMB Capital Case" in the type, write numbers in this cell, and click on other cells with the mouse, so that the numbers will be automatically converted into uppercase amounts.

How to convert numbers into uppercase amounts

The above is the detailed content of How to convert numbers into uppercase amounts. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
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