内容简介:方法:1、打开EXCEL表格,A1输入抄小写金额,在C1列输入:袭=SUBSTITUTE(SUBSTITUTE(IF(A1>-0.5%,,"负")&TEXT(INT(FIXED(ABS(A1))),"[dbnum2]G/通用格式元;;")&TEXT(RIGHT(FIXED(A1),2),"[dbnum2]0角0分zhidao;...
用户评论
voxtech