Current location - Loan Platform Complete Network - Big data management - What are the ways to expand or reduce a column of data 1000 times in Excel?
What are the ways to expand or reduce a column of data 1000 times in Excel?

1. First open the excel table and enter some numbers:

2. Then click on the cell next to the number, and then enter the formula "=C3*1000" to expand it 1000 times , if it is reduced by 1000 times, it will be "=C3/1000". Next to the expansion, enter:

3. Finally, select the two columns of cells where the formula is entered, hold down the mouse and pull down to get all the numbers.

The above is how Excel can expand or reduce a certain column of data 1000 times: