3 Ways to Input Numbers with More Than 15 Digits in Microsoft Excel (+Pictures)

3 Ways to Input Numbers with More Than 15 Digits in Microsoft Excel (+Pictures)

Geekers - Have you ever experienced when you type a long number in Microsoft Excel which has more than 15 digits, but the displayed number doesn't look like the number you typed? And do you know why this can happen?


That's because, when you write a number in an Excel cell with more than 15 digits, Microsoft Excel will convert it to scientific notation format like this 1.23457E+14 or the last digit will change to 0 .



What is scientific notation in Microsoft Excel? Scientific notation is Microsoft Excel's way of expressing numbers that are too large to be written in decimal form. By default, Microsoft Excel will display the scientific notation format for numbers longer than 15 digits.


How to Write Numbers More Than 15 Digits in Microsoft Excel


Microsoft Excel is the most popular number processing application used for data tabulation and calculations. However, there is a limit set by Microsoft Excel for too many numbers. Like numbers on NIK, KK, Account Numbers, Credit Cards, and others.


Is there a way around this? Of course there is! There are several ways you can do in Microsoft Excel to change the number format to a decimal number. Here are some ways you can do it.



First step




The first way you can do that is by adding quotation marks (') before the numbers. How to?

  1. Open Microsoft Excel on the computer, then open your worksheet which already contains numbers of more than 15 digits.

  2. Because the number is more than 15 digits, Microsoft Excel will default to converting the number to scientific notation format. Like the example in the picture. numbers in scientific notation format numbers in scientific notation format

  3. To change the scientific notation format to a decimal number, you can add an exclamation mark (') before the number and then press Enter. Like the example in the picture. How to Input Numbers with More than 15 Digits in Microsoft Excel How to Input Numbers with More than 15 Digits in Microsoft Excel

  4. Then the scientific notation format will change to a decimal number. Like the example in the picture. scientific notation numbers change to decimal numbers scientific notation numbers change to decimal numbers

  5. Do this to the next cell to change the numbers to decimals. excel decimal numbers excel decimal numbers


Second way


The second way that you can do is to change the excel cell format to text. If you have a lot of data, and you think it's too long to do the first method. You can do this second way.

  1. Excel cell blocks that you have made numbers, but still in scientific notation format.

  2. Then right click, then select Format Cells. See an example in the picture. How to Input Numbers with More than 15 Digits in Microsoft Excel How to Input Numbers with More than 15 Digits in Microsoft Excel

  3. Then on the Numbers menu, select Text, then click Ok. Like the example in the picture. select text format select text format

  4. Then automatically the numbers in excel cells will change to decimal numbers.


Third Way


If you haven't created a worksheet in Microsoft Excel, so you don't have to change the number format, you can follow this third method.

  1. Select a cell or column that you will fill with numbers, then on the Home menu in the Number group where there is general writing, click the arrow. See an example in the picture. change excel cell format change excel cell format

  2. Then select Text. See an example in the picture. select text format select text format

  3. Then you can type numbers in cells that have been formatted, and Excel will display them according to the numbers you typed, without changing the number format.


Those are some ways for numbers that are more than 15 digits so that the format doesn't change in Microsoft Excel. Hopefully this article can help those of you who don't know or are confused about how to enter numbers that are more than 15 digits in Microsoft Excel so they don't change.



MORE TUTORIALS

   * 4 Ways to Remove Blank Pages in Microsoft Word

   * 3 Ways to Easily See the Amount of Laptop RAM

   * 2 Ways to Install Norton Antivirus on PC / Laptop

   * 3 Ways to Mount / Unmount ISO Files in Windows

Share:

Top Ads

Responsive Ads

Middle Ads 1

Responsive Ads

Middle Ads 2

Responsive Ads

Bottom Ads

Responsive Ads