EXCEL 数字超过15位使用递增功能  绝对好用

="前14位数字"&text(row(1:1),"0000")
例：818500030000061~818500030000077 用递增功能托。这里递增位数为后面四位所以公式中有4个“0”

 ="81850003000"&TEXT(ROW(61:61),"0000")        显示结果：818500030000061

="81850003000"&TEXT(ROW(62:62),"0000")        显示结果：818500030000062

="81850003000"&TEXT(ROW(63:63),"0000")        显示结果：818500030000063

="81850003000"&TEXT(ROW(63:63),"0000")        显示结果：818500030000063

.

.

.

. 

="81850003000"&TEXT(ROW(77:77),"0000")        显示结果：818500030000077

如果="81850003000"&TEXT(ROW(9999:9999),"0000")    显示结果：818500030009999

那么托的下一个递增效果就为17位数字，如下所示：

="81850003000"&TEXT(ROW(9999:9999),"0000")            显示结果：818500030009999

="81850003000"&TEXT(ROW(10000:10000),"0000")        显示结果：8185000300010000