金額 依單位處顯現 (11465)

B2:H5=LEFT(RIGHT(" "&$A2,8-COLUMN(A1)))

B9:J13=TEXT(LEFT(RIGHT(0&$A9/1%,10-COLUMN(A1))),"0;;")



留言