How to convert Excel numbers to uppercase amounts_How to convert Excel numbers to uppercase amounts

How to convert numbers in Excel to uppercase amounts? PHP editor Yuzai brings you this tutorial to guide you step by step and help you quickly solve this problem.

We take the table below as an example to convert the numbers on the left into uppercase amounts on the right.

1. First, we fill in the equal sign in the uppercase amount cell, then enter the function NUMBERSTRING((, then select the target cell to be converted and add a comma 2. Like this The function is =NUMBERSTRING(B2,2).

2. Press Enter after inputting, and the amount will be automatically converted to uppercase. Finally, you can easily fill the cell down. Complete the conversion of all numbers

## Also, in the =NUMBERSTRING(B2,2) function, the 2 in the brackets represents conversion to accounting case. In fact, there are three types of parameters: 1 , 2, and 3 correspond to Chinese capitalization, accounting capitalization, and mathematics capitalization respectively.

If you want to directly replace the data in the cell with uppercase, then you can directly select the table, right-click the cell properties, and Click [Special] and select Chinese uppercase numbers in the type.

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