本帖最后由 砂海 于 2019-8-29 21:26 编辑
=SUBSTITUTE(TEXT(SUM(MID("00"&SUBSTITUTE($E$11,".","·00000")&"·",FIND("·","00"&SUBSTITUTE($E$11,".","·00000")&"·",{4,11,18,25})-3,3)*10^{9,6,3,0}),"000·000·000·000"),"·",".")
=TEXT(SUM(MID("00"&SUBSTITUTE($E$11,".","·00000")&"·",FIND("·","00"&SUBSTITUTE($E$11,".","·00000")&"·",{4,11,18,25})-3,3)*10^{9,6,3,0}),"000!.000!.000!.000")
-----------------
|