第1个回答 2013-05-26
=IF(G15<0,"负","")&TEXT(TRUNC(ABS(ROUND(G15,2))),"[DBNum2]")&"元"&IF(ISERR(FIND(".",ROUND(G15,2))),"",TEXT(RIGHT(TRUNC(ROUND(G15,2)*10)),"[DBNum2]"))&IF(ISERR(FIND(".0",TEXT(A1,"0.00"))),"角","")&IF(LEFT(RIGHT(ROUND(G15,2),3))=".",TEXT(RIGHT(ROUND(G15,2)),"[DBNum2]")&"分","整")运用是将所有的G15换成目标单元格就可以了。或者下载搜狗或者QQ拼音在中文输入法状态下,先按V然后输入数字即可自动出现大写选项,选择就行了