What should I do if the numbers change to dates after opening Excel?

Solution to the problem that numbers change to dates after Excel is opened: First open the EXCEL worksheet and enter numbers in any cell; then right-click and select Format Cells; then select under the "Numbers" tab "Text"; finally click "OK" in the lower right corner.

The operating environment of this article: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

Solution to change the number into date after excel is opened:

1. First open the EXCEL worksheet.

#2. Then enter a number in any cell.

#3. Right-click and select Format Cells.

4. Select "Text" under the "Number" tab.

5. Finally, click "OK" in the lower right corner.

#6. After completion, the numbers in the cells will not become dates.

Related learning recommendations: excel tutorial

The above is the detailed content of What should I do if the numbers change to dates after opening Excel?. For more information, please follow other related articles on the PHP Chinese website!