Current location - Recipe Complete Network - Complete cookbook of home-style dishes - Why does October 5 appear when I enter 5-10 in the excel table?
Why does October 5 appear when I enter 5-10 in the excel table?

If you enter 5-10 in the excel table, October 5 will be displayed because the cell format is date format. Just change it to text format.

Tools/Materials: Microsoft Office Excel 2016 version, Excel table. ?

1. First select the Excel table and double-click to open it. ?

2. Then on the Microsoft Office Excel 2016 version window, select the cell that displays May 10.

3. Furthermore, on the Microsoft Office Excel 2016 version window, right-click the "Format Cells" option. ?

4. Secondly, on the Microsoft Office Excel 2016 version window, select "Text" and the example "5-10" is displayed on the right side. ?

5. Continue on the Microsoft Office Excel 2016 version window and click the "OK" button. ?

6. Finally, in this interface, cells 5-10 are successfully displayed.