I'm doing calculations and I would like to keep all the data in scientific notation to the powers of 3 like I do when I'm doing real life calculations, currently I'm getting 7.025E7 instead of 70.25E6.
Thanks in advance
Formating individual cells, changing the amount of decimals.
Thank you guys, I chose a modification of chris neilsen's answer. I ended up using a custom format of ###.###E+0
Screen shots as requested by @Tom Sharpe
Custom format I entered into Excel 2019
End result of data in Excel 2019 Some of the cells in screen shot 2 do not have the custom format (cells displaying 0, 1, 1000) also row 10 displaying 825.043
