First step: Run Excel, click to select the columns you want to format. Right-click the selected column and choose Format cells (Figure 1) from the shortcut menu that pops up.
Step two: In the Open Cell Format dialog box, in the Number tab, select the custom item, and in the text box below the type (T):, enter "0.00" CM "(see Figure 2, without outside quotes), and finally click the OK button.
After this setting, when you enter data in the column cell, you don't have to consider the unit problem, just enter the number.
Tip: Where "0.00" means that the column cell retains two decimal places, and a few "0" after the decimal point represent several decimals, and how much you can set yourself up on demand. If it is another unit symbol, just change the cm in double quotes as the corresponding character.