Open the table that needs to be converted, and the uppercase amounts are displayed in a separate column.
Select all cells under uppercase amounts.
Right click and select "Format Cells" as shown below. You can also use the shortcut key "Ctrl 1" and then select "Special".
Select "RMB Capitalization" in Special and then confirm.
We enter "6000" in the cell and press Enter.
When "Lu Qian Yuan" appears, you can compare it with the left side. The left side is a capital number, not the amount.
Enter "500" in the next cell, press Enter, and the amount in capital letters is correct.
Recommended related articles and tutorials:excel tutorial
The above is the detailed content of How to convert numbers to uppercase amounts in excel. For more information, please follow other related articles on the PHP Chinese website!