Long numbers in Excel (type and long numbers in scientific notation are displayed in their entirety)
Entering long numbers are automatically converted to scientific notation in Excel. This is because only 11-digit numeric numbers are shown by default, and more than 11 digits are automatically represented by scientific notation.
Chapters:
0:00 How to type long numbers in Excel?
0:53 The long numbers expressed in scientific notation are displayed in their entirety
Description:
Long numbers in Excel (type and long numbers in scientific notation are displayed in their entirety)
In older versions, beyond 15 digits, the numbers that are behind 15 digits are automatically converted to zeroes. How to enter long numbers in Excel without turning to scientific notation? If we want to show long numbers longer than 11 digits in their entirety, we need to convert the numeric type to the tex.
One. How to type long numbers in Excel without turning to scientific notation
(1) Method 1: Enter single quotation marks (') first, and then enter the number
1. Enter quotation marks ('), and then enter the numbers, press Enter on the keyboard, they are still a long number, and they are not converted to scientific notation, and the quotation marks entered first are gone.
2. Entering quotation marks and then long numbers is actually converting numbers to text, so no matter how many digits are entered, they will not be converted to scientific notation.
(2) Another way: Format the cell we want to enter as text first, and then enter the numbers
1. Select the A3 cell, press Ctrl + 1 on the keyboard to open the "Format Cells" window, select "Text" on the left, click "OK", enter the long number as well, click other cells with the pointor to end the input, and they are not converted to scientific notation.
2. If you don't format the cell as text before entering and enter a number, Excel will automatically convert it to a numeric type, and the numbers that are the numeric type more than 11 digits will be converted to a scientific notation. Also, if you want to enter long numbers in multiple cells, you can select them at once and then format the cells as text.
Two. The long numbers expressed in scientific notation are displayed in their entirety
Convert the two long numbers entered above into numeric values, and the long numbers are represented by scientific notation; Press Ctrl + 1 on the keyboard to open the “Format Cells” window, select “Custom” on the left, enter 0 under “Type” on the right, and click “OK”, then the long numbers represented by scientific notation will be displayed in full.
Watch video Long numbers in Excel (type and long numbers in scientific notation are displayed in their entirety) online without registration, duration hours minute second in high quality. This video was added by user Loinsure 13 May 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 154 once and liked it 0 people.