How do you divide all values in the worksheet by 1000000

[Franz]

1) write the vlue you want to divide by in a cell;
2) select that cell and then copy;
3) select the range you want divide and then select Edit, CopyPasteSpecial
and clic ond option Divide;
4) clic OK.

Hoping to be helpful

Regards

P.S.: It's not polite writing a post blank with a question just in the
subject...