Automatically add quantity units to cells

Source: Internet
Author: User

At the beginning of the year, is the peak of the production of various reports, in many cases the financial staff need to add units to the data in the cell, such as the unit's annual financial budget report, you need to add the unit "Yuan" to the cell data. Encountered this situation, many friends are manually added, is very cumbersome. In fact, in the Excel report, we implement automatic to add units for the single data without grid.

Select all cells that you want to add units to, and then click Format/Cells. In the Cell Format dialog box that pops up, switch to the Number tab, select Customize in the Category list box, and choose the data format you want in the Type list box, such as 0.00, and finally the type The number of units needed in the back of the data format in the text box, such as "Meta", and click "OK" when finished (Figure/). OK, now in Excel one by one input data, Excel will automatically add the number of units for each cell, is once and for all, very convenient.

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: info-contact@alibabacloud.com 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.