In Google Sheets when I enter


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


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. 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


| improve this answer | |
  • 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 '19 at 16:38
  • 1
    @Bunji Try 0.0E+00 – Rubén Jun 14 '19 at 16:39
  • Unfortunately, I don't think this works. It still shows up as 8.0E-13 – Bunji Jun 16 '19 at 17:05

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:


| improve this answer | |

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.