扫码登录即表示您同意并遵守 用户协议
成就自己的只需一套精品 联合大牛讲师,汇集优秀课程,培养可交付的程序员!
=IF(A2=0,"",IF(A2<0,"负","")& SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TEXT(INT(ABS(A2)),"[DBNum2]")&" 元"&SUBSTITUTE(SUBSTITUTE(TEXT(RIGHT(A2*100,2),"[DBNum2]0角0分"),"零分"," 整"),"零角","零"),"零元零",),"零元",),"零整","整"))
© 著作权归作者所有
发表评论
自媒体入驻学习猿地,
获百万流量,打造个人技术品牌
学习猿地程序员学习的地方