How to easily set up data to display thousand units in Excel

Today's case tutorials introduce a way to quickly add numbers to millions of units, and unify all numbers to reduce the unit's magnification.

Operation Steps:

1, in the Excel2013, first copy H2 cell data, CTRL + C key Copy, select the F2:f6 area, click Paste-paste-selective.

2, pop-up Selective Paste dialog box, paste as a numerical value, the operation of the choice of rules, determine.

3, right click, pop-up right-click menu, set cell format.

4, in the Number tab, classification selection for the custom, type after the thousand words, determine.

5, finally, the total price of the data in the cell into a thousand units, 2 million Yuan, is 2000 after the addition of 3 0.