excel金额大小写转换用于送货单据吗?可以转换成,例如:1000元,零拾零万壹仟零佰零拾零元零角零分整
IF(E64=0,"",IF(INT(E64),TEXT(TRUNC(E64),"[dbnum2]")&"元",""))&IF(MOD(E64,1)=0,"整",IF(TRUNC(E64,1),IF(E64=TRUNC(E64,1),TEXT(LEFT(RIGHT(E64*100,2)),"[dbnum2]0角整"),TEXT(RIGHT(E64*100,2),"[dbnum2]0"&IF(LEFT(RIGHT(E64*100,2))="0","","角")&"0分")),TEXT(B2*100,"[dbnum2]0分"))),E64改为你数据所在单元格就可以了。