How to automatically add units of measurement when Excel enters data

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