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: