First copy and paste the lowercase amount into the uppercase amount cell, select the uppercase amount cell, right-click, and select Format Cells
Then in the cell format, select Special, and then select the last RMB capital case
# in the type on the right
##After completing the above operations, the lowercase amount will automatically be converted into uppercase amount. Recommended tutorial:The above is the detailed content of How to convert lowercase numbers to uppercase amounts in excel. For more information, please follow other related articles on the PHP Chinese website!