If you want to divide all the values in a column by a constant value (e.g. divide all values in column A by 100), you can use the formula =A1/100 and then use Autofill to apply the formula to the other cells in the column.