2. Next, click the right mouse button in the bank card number cell to display the function menu;

3. Select the "Cell Format" option in the function menu bar;

4. Select the "Custom" option in the classification;

4. Add and change the type on the right. Format as shown in the figure, click OK.

5. This is the bank card number format, which shows all the bank card numbers.