="人民币(大写):"&IF(M6<0,"负","")&IF(M6=0,"",IF(ABS(M6)<0.995,"",IF(AND(RIGHT(INT(ROUND(ABS(M6),2)/10000))="0",RIGHT(INT(ROUND(ABS(M6),2)/1000))<>"0"),SUBSTITUTE(TEXT(INT(ROUND(ABS(M6),2)),"[DBNum2]"),"万","万零"),TEXT(INT(ROUND(ABS(M6),2)),"[DBNum2]"))&"元")&IF(RIGHT(TEXT(M6,".00"),2)*1=0,IF(ABS(M6)<0.005,"","整"),IF(ABS(M6)<0.095,"",IF((LEFT(RIGHT(TEXT(M6,".00"),2))<>"0")*(ABS(M6)>=1),IF(RIGHT(TRUNC(M6),1)>="1","","零"),"")&TEXT(LEFT(RIGHT(TEXT(M6,".00"),2)),"[dbnum2]"))&IF(LEFT(RIGHT(TEXT(M6,".00"),2))*1=0,"","角")&IF(RIGHT(TEXT(M6,".00"))*1=0,"整",TEXT(RIGHT(TEXT(M6,".00")),"[dbnum2]")&"分"))) |