Home >Software Tutorial >Office Software >How to express numbers as uppercase Chinese numeric amounts in Excel

How to express numbers as uppercase Chinese numeric amounts in Excel

PHPz
PHPzforward
2024-04-17 11:37:01674browse

Right-click the cell that needs to display the amount in uppercase, and select [Format Cells] in the pop-up shortcut menu.

How to express numbers as uppercase Chinese numeric amounts in Excel

Select the [Number] tab in the pop-up dialog box, select [Special] in the [Category] list, select [Chinese uppercase numbers] in the type box, and click [OK] Select this type.

How to express numbers as uppercase Chinese numeric amounts in Excel

After setting, Excel numbers will automatically be converted into uppercase amounts, so you don’t have to enter capital letters every time when inputting.

How to express numbers as uppercase Chinese numeric amounts in Excel

The above is the detailed content of How to express numbers as uppercase Chinese numeric amounts in Excel. For more information, please follow other related articles on the PHP Chinese website!

Statement:
This article is reproduced at:zol.com.cn. If there is any infringement, please contact admin@php.cn delete