How to uniformly add number prefixes in excel

How to uniformly add numerical prefixes in excel

Add prefix numbers in batches to EXCEL table cells, you can add them in " Add prefix numbers in batches in "Format Cells".

Recommended: "Excel Tutorial"

The method steps are as follows:

1. Open the EXCEL table that needs to be operated, and select the cells that need to add prefix numbers. Cell, enter "Format Cells" through keyboard "Ctrl 1".

2. Find and click "Customize" in the number tab, then enter: "6"0 in the text input box under the type on the right, and click Just click the OK button below.

#3. Return to the EXCEL table and you can find that prefix numbers have been successfully added to the cells in batches.

The above is the detailed content of How to uniformly add number prefixes in excel. For more information, please follow other related articles on the PHP Chinese website!