Automatically add quantity units to cells

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.