How to set uppercase amounts in Excel in Canadian dollars

Setting method: First open the excel table that needs to be operated and select the specified cell; then right-click the mouse and select "Format Cells" in the pop-up right-click menu; then in the new window that pops up, Select "Special" for "Category", select "RMB Capital" for "Type"; finally click the "OK" button.

The operating environment of this tutorial: windows7 system, wps office2016 version, Dell G3 computer.

First click on the table on the desktop to open it. After opening the table, select the data that needs to be converted.

# Then right-click the mouse and select Format Cells in the pop-up window.

After entering the cell formatting page, select Special in the number column and select RMB uppercase in the type.

#Finally click OK, so that when the number in Excel automatically converts the amount to uppercase, it will automatically add yuan.

Related learning recommendations: excel tutorial

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