从右向左三位数字用“0”补齐

Lucas-ni · 发表于 2024-1-26 14:04

从右向左用0补齐三位.

jivy1212 · 发表于 2024-1-26 14:08

本帖最后由 jivy1212 于 2024-1-26 14:12 编辑

复制代码

21版，下面是低版数组

=TEXT(SUM(TEXT({1,-1,0,""},""""&SUBSTITUTE(A2,"-",""";""")&"""")*10^{7,5,3,0}),"0-00-00-000")

复制代码

Lucas-ni · 发表于 2024-1-26 14:10

jivy1212 发表于 2024-1-26 14:08
21版

十分感谢。已成功

hxj119 · 发表于 2024-1-26 14:18

=LEFT(A2,FIND("#",SUBSTITUTE(A2,"-","#",3)))&TEXT(1*MID(A2,FIND("#",SUBSTITUTE(A2,"-","#",3))+1,3),"000")

hxj119 · 发表于 2024-1-26 14:53

高版本，参考公式：
=TEXTBEFORE(A2,"-",-1)&TEXT(TEXTAFTER(A2,"-",-1),"-000")

袁勇 · 发表于 2024-1-26 15:23

低版本。

=SUBSTITUTE(A2,"-","-"&REPT("0",3-LEN(TRIM(RIGHT(SUBSTITUTE(A2,"-",REPT(" ",99)),9)))),3)

复制代码

hcm19522 · 发表于 2024-1-26 16:57

=SUBSTITUTE(A2,"-","-"&REPT(0,3-LEN(MID(A2,MATCH("-",MID(A2,{9,10,11},1),)+9,9))),3)

橒♂蝣 · 发表于 2024-1-26 22:17

=TEXTBEFORE(A2,"-",3)&"-"&TEXT(TEXTAFTER(A2,"-",3),"000")

静听溪流 · 发表于 2024-1-27 10:53

=TEXTJOIN("-",,TEXT(TEXT({1,-1}%,SUBSTITUTE(A2,"-",";",3)),{"e-m-d","000"}))

一剑惊心 · 发表于 2024-1-27 14:07

=TEXTJOIN("-",,TEXT(TEXTSPLIT(A2,"-"),{0,0,0,"000"}))

		自动登录	找回密码
密码			免费注册

[已解决] 从右向左三位数字用“0”补齐