How to Convert numbers to uppercase functions in an excel worksheet

Source: Internet
Author: User
Tags arabic numbers

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!

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.