What I want to do is divide those numbers by 1000. In my table here, you can see I've got some quantities, all in the millions.
Today, we're going to take a look at a feature where you can permanently change numbers by adding, subtracting, multiplying, or dividing, without using a formula.
Here is the full transcript of the video: Divide Excel Numbers Without Formulas. Video Transcript - Divide Without Formulas To complete the change, you can format the numbers, if necessary,.
Each of the selected numbers is automatically divided by 1000.In the Options section, click Divide, then click OK.On the Ribbon's Home tab, click the arrow on the Paste button,.In the screen shot below, cells C2:C11 are selected. Select the cells which contain the amounts that you want to divide.Copy the cell which contains the division amount.In this example, 1000 was entered in cell F3 In a blank cell, enter the amount by which you want to divide.In this example, numbers are dividedīy 1000, and the result is a permanent change to the numbers. Without using formulas, you can quickly divide a set of numbers,īy using the Paste Special command. Written instructions, and the full video transcript, are below the video. Watch this short video to see the steps for dividing numbers with On the worksheet, each of the selected numbers is automatically decreasedīy $1.25 Divide Numbers With Paste Special In the Operation section, click Subtract, then click OK.Optional - In the Paste section, click Values, if you don't want to copy the formatting from the copied cell (D3).Select the cells that have the amounts you want to decrease.