2. Select the cell (or column or row) to set the serial number, right-click to customize the cell format, insert the cursor into the custom input box, then click № Insert symbol at the special character, and finally set the custom format as shown in the figure.