數字改大写 (10535)


D10=LEFT(RIGHT(TEXT($O9*100,"[dbnum2] ¥0"),11-COLUMN()/2))


另解=TEXT(LEFT(RIGHT(" ¥"&$O9*100,11-COLUMN()/2)),"[dbnum2]")


D10複製到各格


留言