摘要:
123.09 = 壹佰贰拾叁元零玖分=SUBSTITUTE(SUBSTITUTE(IF(G10<0,"負","")&TEXT(TRUNC(ABS(ROUND(G10,2))),"[DBNum2]")&"元"&IF(ISERR(FIND(".",ROUND(G10,2))),"",TEXT(RIGHT(TRUNC(ROUND(G10,2)*10)),"[DBNum2]"))&IF(ISERR(FIN... 阅读全文
posted @ 2015-07-20 07:35 Warrior Sun 阅读(422) 评论(0) 推荐(0) 编辑