EXCEL中文金额转换

    技术2022-05-19  21

    =TEXT(INT(A1),"[dbnum2]G/通用格式元;;")&SUBSTITUTE(SUBSTITUTE(TEXT(RIGHT(RMB(A1),2),"[dbnum2]0角0分;;整"),"零角",IF(A1^2<1,,"零")),"零分","整")


    最新回复(0)