How to convert Excel numbers to uppercase amounts - a hidden function

Are you worried about converting numbers into uppercase amounts in Excel? PHP editor Youzi brings you a simple and practical solution. This article will introduce a little-known Excel hidden function to help you solve this problem easily. Read on to learn how to use this function to quickly and accurately convert numbers to uppercase amounts.

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. Such a function is =NUMBERSTRING(B2 ,2).

2. Press Enter after entering, and the amount will be automatically converted into uppercase amounts. Finally, fill in the cells downwards and you can easily get all the numbers. Conversion.

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 - a hidden function. For more information, please follow other related articles on the PHP Chinese website!