如何计算下列数据的个数，并在少一位的数据前加0

江东勒布朗

13066
94237
94159
3004
11043
14059
6213
96133
90022
17132
各位大佬如何在表格中实现此功能呀
96117

6211
95084
95031
94035
95037
9300
8302
16129
13208
14067
16119
16122
92106
94022

悲枫遗落

林中

=TEXT(A1,"00000")

落叶忆昔

=RIGHT("00000"&A1,5)

仔歌

我也要来个不一样的
=REPT("0",4-LEN(A2))&A2

姜葱炒肉蟹

=TEXT(A1,"00000;;无数据")
短点的
=BASE(A1,10,5)

常凯申参谋总长朱可夫

再来补几条
=IF(A2>999，"",IF(A2>99,"0",IF(A2>9,"00","000")))&A2

=VLOOKUP(LEN(A2),{1,"000";2,"00";3,"0";4,""},2,0)&A2


=LOOKUP(LEN(A2),{1,2,3,4},{"000","00","0",""})&A2

=CHOOSE(LEN(A2),"000","00","0","")&A2

出外的囝仔

C2{=RIGHT(REPT(0,9)&B2,MAX(LEN(B$2:B$9)))
D2{=TEXT(B2,REPT(0,MAX(LEN(B$2:B$9))))

正在读取

非常感谢，楼上大佬的解读和解答。