How to Convert numbers to uppercase functions in an excel worksheet

Enter a value in cell a1.

Click cell b1 with the left mouse button, enter = numberstring (), and then click inside the brackets.

Click cell A1.

Enter a half-width comma, a 1, and then click the green check mark.

The return value of the function is changed to a large Chinese number displayed in the form of one, two, three.

Click the position at the front of the second parameter 1 of the function, and drag backward to select 1. The background of 1 is black, and then enter 2 on the keyboard.

Enter 2 and then click the green check mark to complete the input.

At this time, the return value of the function is a large number in upper case.

If the third parameter is 3, the function returns a digital value instead of a large number. The digital value is in the format of uppercase and lowercase.

The above is the function to convert Arabic numbers into Chinese uppercase numbers in excel. I hope it will help you!