How to batch input serial numbers with brackets in Excel_Sharing tips for batch inputting serial numbers with brackets in Excel

Want to batch input serial numbers with brackets in Excel, but can’t find a way? Stop worrying! PHP editor Youzi brings you tips on batch inputting serial numbers with brackets. Next, we will introduce this technique in detail so that you can easily solve this problem.

First select the cell below the serial number, right-click to set the cell format:

Click on the number, then set it to text format, click OK:

Enter (1) in the first cell, hit the Enter key, and a serial number with brackets will be born:

Then drag and hold Quickly fill in the small dots in the lower right corner and then fill them in sequence:

This is done:

The above is the detailed content of How to batch input serial numbers with brackets in Excel_Sharing tips for batch inputting serial numbers with brackets in Excel. For more information, please follow other related articles on the PHP Chinese website!