1、打开需要操作的EXCEL表格，如图所示；
/iknow-pic.cdn.bcebos.com/6609c93d70cf3bc7c3c6aebcdf00baa1cc112a9f"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/6609c93d70cf3bc7c3c6aebcdf00baa1cc112a9f?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/6609c93d70cf3bc7c3c6aebcdf00baa1cc112a9f"/>
2、接下来在银行卡号单元格单击鼠标右键，出现功能菜单；
/iknow-pic.cdn.bcebos.com/4bed2e738bd4b31c2d7efbeb89d6277f9e2ff824"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/4bed2e738bd4b31c2d7efbeb89d6277f9e2ff824?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/4bed2e738bd4b31c2d7efbeb89d6277f9e2ff824"/>
3、选择功能菜单栏里面的“设置单元格格式”选项；/iknow-pic.cdn.bcebos.com/908fa0ec08fa513deac30e8e336d55fbb2fbd971"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/908fa0ec08fa513deac30e8e336d55fbb2fbd971?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/908fa0ec08fa513deac30e8e336d55fbb2fbd971"/>
4、选择分类里面的“自定义”选项；
/iknow-pic.cdn.bcebos.com/64380cd7912397dda7cffa545782b2b7d0a2872f"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/64380cd7912397dda7cffa545782b2b7d0a2872f?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/64380cd7912397dda7cffa545782b2b7d0a2872f"/>
4、加下来对右侧的类型进行更改，格式如图所示，点击确定；
/iknow-pic.cdn.bcebos.com/10dfa9ec8a136327a433a0639f8fa0ec09fac780"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/10dfa9ec8a136327a433a0639f8fa0ec09fac780?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/10dfa9ec8a136327a433a0639f8fa0ec09fac780"/>
/iknow-pic.cdn.bcebos.com/0b46f21fbe096b6316d7330002338744eaf8ac90"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/0b46f21fbe096b6316d7330002338744eaf8ac90?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/0b46f21fbe096b6316d7330002338744eaf8ac90"/>
5、这是银行卡号格式就设置好了，银行卡号全部显示出来了；
/iknow-pic.cdn.bcebos.com/5bafa40f4bfbfbed2185582f76f0f736aec31f85"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/5bafa40f4bfbfbed2185582f76f0f736aec31f85?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/5bafa40f4bfbfbed2185582f76f0f736aec31f85"/>