How to automatically add units of measurement when Excel enters data

Source: Internet
Author: User

How to automatically add units of measurement when Excel enters data

When we do data entry in a cell, we often need to add some units. For example, amount per unit yuan, fractional unit element. If the frequent repetition of these units significantly more trouble, in fact, we can use the custom format to implement automatic add units of measurement.

Select the cells that you want to automatically add units of measurement to, and then open the Cells command under the Format menu. Switches the Open Cell Formatting window to the Number tab, select Custom in the Category list, select the corresponding data format in type, and add the corresponding unit of measurement after the selected data type's formatted text, such as dollars, cents (Figure 1). When set, click OK to automatically add the preset units when data is entered in a formatted cell.

Figure 1 Excel input data automatically add unit of measurement

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.