问题描述:
在EXCLE表格内,何装1位数,2位数都就成三位数.如1变成001,10变成010
SR3-B14-N0256SR3-B14-N0257SR3-B14-N0258SR3-B14-N0259SR3-B14-N0260SR3-B14-N0261SR3-B35-N0262SR3-B35-N0263SR3-B35-N0264SR2-B39-00305SR3-A102-00478SR3-A102-00480SR3-A86-00165SR3-A86-00166SR2-B39-00511
想将这一列中间的数值变成三位数,如下:
SR3-B014-N0256
SR3-B014-N0257
SR3-B014-N0258
SR3-B014-N0259
SR3-B014-N0260
SR3-B014-N0261
SR3-B035-N0262
SR3-B035-N0263
SR3-B035-N0264
SR2-B039-00305
SR3-A102-00478
SR3-A102-00480
SR3-A086-00165
SR3-A086-00166
SR2-B039-00511
原本是这样的,刚才输入有问题
SR3-B14-N0256SR3-B14-N0257SR3-B14-N0258SR3-B14-N0259SR3-B14-N0260SR3-B14-N0261SR3-B35-N0262SR3-B35-N0263SR3-B35-N0264SR2-B39-00305SR3-A102-00478SR3-A102-00480SR3-A86-00165SR3-A86-00166SR2-B39-00511
想将这一列中间的数值变成三位数,如下:
SR3-B014-N0256
SR3-B014-N0257
SR3-B014-N0258
SR3-B014-N0259
SR3-B014-N0260
SR3-B014-N0261
SR3-B035-N0262
SR3-B035-N0263
SR3-B035-N0264
SR2-B039-00305
SR3-A102-00478
SR3-A102-00480
SR3-A086-00165
SR3-A086-00166
SR2-B039-00511
原本是这样的,刚才输入有问题
问题解答:
我来补答展开全文阅读