How to

How to Turn off Scientific Notation on Google Sheets

How to Turn off Scientific Notation on Google Sheets

Scientific notation is very helpful when you deal with numbers that are too big or too small. While chemists or engineers use scientific notation all the time, most of us don’t. What’s more, it can be rather annoying, because it shows information that it’s not relevant to you.

Do not worry. You can turn it off faster than you think. In this article, we will show you how to do it on Google Sheets.

Turn off Scientific Notation on Desktop

If you have dealt with scientific notation in Excel, you will recognize some of the steps shown below. The process is fast and easy. However, instead of just turning off this option, you will switch to another option. Here’s what you have to do:

  1. Open your spreadsheet.
  2. Click on Format.
  3. Click on the Number (or the “123” sign).
  4. You will see that the “Scientific” option is selected.
  5. Deselect and choose another option.

There she is! Turning off scientific notation has never been easier. Once when you turn it off, it must still die. However, if it is revived, you now know how to handle it.

Tip: Most people choose the “Number” option because it’s quite universal. Unless you write financial statements or want to format the date, this option should work for you.

1(2)

Turn off Scientific Notation on Mobile

You can do this on your cellphone too. However, you might need to download the Google Sheets Apps first, if you don’t have one already. If you have an iPhone. If you use an Android device, you can find it here. Next, follow these steps:

  1. Open your spreadsheet.
  2. Select cell range.
  3. Tap on Format.
  4. Tap on Cell.
  5. Tap on the Number format.
  6. You will see that the “Scientific” option is selected.
  7. Deselect and select another option from the list.

If you are not sure what to choose, you can just choose “Number”, because this is the option most of us use.

Can I Revive Scientific Notion Again?

Of course! You can do it anytime you want. However, remember that it might not automatically apply to all cells. If you have already filled in some cells with data when this option turns off, you might need to select those cells and then turn them on. Here’s how:

  1. Click on Format.
  2. Click on Number.
  3. Select the “Scientific” option.

There is no limit to the number of times you can change the format, which is fantastic.

Format Numbers

If you follow our guidelines, you might see several options under the Number sign. We will explain some of the most important:

  1. Format Date – You can choose the date format used or the international date format (first year). If you want Google Sheet to write the month’s name instead of the number, click More Format and select this option.
  2. Format Time – There are various time options, too. Most of them include hours and minutes, but if you want to add more specific times, you can find this option under More Formats.
  3. Currency – To change currency, click on More Formats, then on More Currency. You should be able to find all the world currencies there. You can also adjust how many decimal places you want to display.

Finally, if nothing helps, you can always add your special formatting:

  1. Click on Number.
  2. Click on More Formats
  3. Click on Custom Number Format.

You can set whatever format you like. If you want to make a difference between two groups of numbers, maybe even and even numbers, you can adjust the colors for each number. To do this, you must write the color you want in parentheses – for example, (Red).

2(2)

Useful but not always

We hope you now have a better understanding of how to format number functions on Google Sheets. As you can see, Scientific Notation is a pretty cool feature, but not for everyone. You now know how to turn it off if it bothers you. In addition, you can adjust the display of numbers.

Related posts

How to get rid of Bing on Chrome, IE and Microsoft Edge

Howto

How to Clean Gmail Sidebar

Howto

How to Type Emoji on a Chromebook

Howto

How to Add Music to Instagram Stories

Howto

How to use Panning Hand from Microsoft Office instead of the Scroll Bar

Howto

How to use Collections on Microsoft Edge

Howto

How to you track a child’s phone without them knowing

Howto

How to Get Rainbow Story on Instagram

Howto