In Excel, when the number input is too small or too large, the system will automatically round it.This processing method is determined according to the internal agreement of the computer system. Different languages and operating systems may have some differences. If you find that a number is displayed as a decimal after entering it, it is likely that the number has exceeded the allowed range.For example, when you enter a very large year, month or day in the date and time function, the system will convert them to six digits with two decimal places. To solve this problem, you can try to adjust the number format settings of the Excel worksheet.To do this, select the cell to adjust the format, click Data Tools on the Data tab, and select Data Format in the pop-up menu.Then, select the appropriate number format in the pop-up dialog box. In addition, if you want to precisely control the display format of a column of data (including the number of decimal places), you can also use formulas to achieve it.For example, enter the following formula in cell A1: =A1 Then hover the mouse over the formula and click the right button, and select "Format Value" in the pop-up menu. I hope the above content can help you!
