How to divide or multiple an individual cell to convert decimals in Numbers

Use two columns.

Enter the unconverted values in the first column (B)

Place the formula (B2/1000) in the second column.

"Also how would I apply that formula to a majority of the cells?"

'Each formula' needs to be in the cell in which the result is to be displayed. If that's also the cell where you have entered the value to be converted, then whatever you enter in the cell will replace what was there before.

If you enter the formula, then enter a value, the entered value will replace the formula.

If you enter a value, then enter a formula, the the formula will replace the value (and, because the formula references the cell that used to contain the value, but now contains the formula, the formula will return a self reference error and place an error triangle in the cell..

"Would I have to choose each cell individually since the original formula references that first cell?"

Using the formula above, entered in C2, and with the original values entered in column B, starting with B2, follow these steps to fill the formula into the rest of the cells in column C:

• Enter the formula as shown in cell C2. Click the green checkmark button to confirm the formula and close the editor.
• Hover the pointer near the bottom edge of cell C2. A Fill Control (small yellow circle) will appear.
• Place the pointer on the fill control, click and hold and drag down to fill the formula into as many cells in column C as are needed.

Numbers will automatically increment the cell reference by 1 for each row into which the formula in filled.

Regards,

Barry

A cell can contain user input or it can contain a formula, not both.

A cell cannot reference itself, that would be circular. For example if the formula was "divide this cell by 1000" and somehow you could you enter the number 700, it would divide 700 by 1000 to get 0.70. Now it has the number 0.70 so it divides that by 1000 to get .00070 and so on and so on.

You can format the cell to display 700 as 0.7K or 0.70 if that will suffice. The number in the cell will still be 700, it just shows it as 0.7K or 0.7. Any actual division by 1000 will have to be done in another cell/column.