大寫且小數点 化点字 (9691)


C2{=REPLACE(MID(TEXT(9&SUBSTITUTE(-LOOKUP(9,-LEFT(B2,ROW($1:$9))),".",),"[dbnum2]0"),2,9),IFERROR(FIND(".",B2),9),,IF(ISERR(FIND(".",B2)),"","点"))&MID(B2,COUNT(-MID(B2,1,ROW($1:$9)))+1,9)


留言