Current location - Recipe Complete Network - Complete cookbook of home-style dishes - How to display student number in excel
How to display student number in excel

Enter "20180123" in the general format. 20180123 is the same part of the student's student number. Different parts are represented by hash marks. If there are many students and there are single numbers, then we should enter three a pound sign

Click OK, and then just enter the different digits of the student number in the cell where you enter the student number

Press Enter to display the student number All