P2输入公式为:
=TEXT(MID(TEXT($J2*100,"0000000"),COLUMN(A1),1)+0,"[dbnum2]")
复制粘贴到P-V所有区域即可
效果如下图:
=LEFT(RIGHT("零"&ROUND($A2*10000,2)*100,12-COLUMN(A:A)))
=TEXT(LEFT(RIGHT("零"&ROUND($A2*10000,2)*100,12-COLUMN(A:A))),"[dbnum2]")