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: