數字均改三位數 (9465)

 

 B2:B9{=SUBSTITUTE(TEXT(SUM((0&TRIM(MID(SUBSTITUTE(A2,".",REPT(" ",99)),ROW($1:$5)*99-98,99)))*10^{12;9;6;3;0}),REPT("000!.",4)&"000"),".000",)