You could try making a source cell with the original number and enter a
formula to divide by 1,000,000. And then go to formatcellsnumber
decimal places 1.