In spreadsheet applications, when we enter a long number (up to 11 digits or more), the number will automatically What is the reason for the change into decimal representation? The reason why the number changes is because the number will automatically be counted in scientific notation when it reaches 11 digits, and when the number exceeds 15 digits, the following digits will automatically become 0.
The specific handling method for this situation is as follows:
The first step is to select the location of the number to be entered
The second step is to find the cell formatting module in the format bar
The third step is to find the classification option in the number column in the cell formatting
The fourth step is to find the text sub-item in the classification option under the number column, click OK to complete the setting
The fifth step Re-enter the numbers to complete the intended input of the numbers
For more Excel-related technical articles, please visit theExcel Basic Tutorialcolumn!
The above is the detailed content of Why does the excel sheet change when I enter numbers?. For more information, please follow other related articles on the PHP Chinese website!