Current location - Loan Platform Complete Network - Big data management - How to enlarge or reduce a column of data by 1000 times in an Excel table?
How to enlarge or reduce a column of data by 1000 times in an Excel table?
1, first open the excel table and enter some numbers:

2. Then click the cell next to the number, and then enter the formula "=C3* 1000", which means expanding 1000 times, and reducing 1000 times, which means "=C3/ 1000 times". Next to the extension, enter:

3. Finally, select two columns of cells in the input formula, hold down the mouse and drop down to get all the numbers. The above is how Excel enlarges or shrinks a column of data 1000 times: