0

In Google Sheets when I enter

10E-12

in a cell formatted for scientific notation, it automatically turns the number into

1E-11

Though technically correct, this is really annoying when comparing numbers between cells. Is there a way to specify the power to which the number should be raised in Google Sheets?

1
  1. Select the cell(s)
  2. Click on Format > Number > More formats > Custom number format...
  3. On the box write something like #0.0E+00
  4. Click Apply button

Note: The leading # is to set an optional digit

Reference

  • 1
    Thank you very much! Is there also a way to go in the other direction? (i.e. if I want 8E-13 to display as 0.8E-12) – Bunji Jun 14 at 16:38
  • 1
    @Bunji Try 0.0E+00 – Rubén Jun 14 at 16:39
  • Unfortunately, I don't think this works. It still shows up as 8.0E-13 – Bunji Jun 16 at 17:05
0

1.79769E+308 is the maximum number that Google Sheets is able to output. Respectively -1.79769E+308 is the negative value. Anything higher than that will output into error or gets down-corrected by Google Sheets.

Raising on the power in Google Sheets is done with ^ symbol like:

=25^7
=999^99

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.