This is close and results in 1.2×10^-12, but I don't know how to add superscripts to only parts of a cell which is calculated by a formula. I have found this method to reformat scientific notation, which boils down to using the following formula (in A2 to convert A1): Is there a way of automating this process? In LaTeX for instance, there are a number of packages (for example siunitx) which define macros which automate at least the conversion, so you can type \num in LaTeX and then just using the macro everywhere instead of the number. This in turn leads to avoidable typing errors in our documents. This leads to a barrier between for instance Excel and Word where we can no longer simply copy-paste or even better embed the results. In scientific writing, this is frowned upon and we use explicit multiplication and superscripts for powers like 1.23×10⁻¹². When doing computer calculation, scientific notation is mostly represented as 1.23e-12.