Question

怎样在EXCEL中数字转人民币大写

Answer 1

右键，设置单元格格式    特殊  

Answer 2

可以用这个函数，相对比较简单一些：
=IF(A1<=0,,TEXT(INT(A1),"[dbnum2]人民币G/通用格式")&"元"&IF(INT(A1*10)-INT(A1)*10=0,IF(INT(A1)*(INT(A1*100)-INT(A1*10)*10)=0,"","零"),TEXT(INT(A1*10)-INT(A1)*10,"[dbnum2]")&"角")&IF((INT(A1*100)-INT(A1*10)*10)=0,"整",TEXT((INT(A1*100)-INT(A1*10)*10),"[dbnum2]")&"分"))

Answer 3

这里引用的是C3单元格，在记事本里改一下，再复制到Excel里就可以了！
以下就是函数了：="大写："&IF(TRIM(C3)="","",IF(C3=0,"","人民币"&IF(C3<0,"负",)&IF(INT(C3),TEXT(INT(ABS(C3)),"[dbnum2]")&"圆",)&IF(INT(ABS(C3)*10)-INT(ABS(C3))*10,TEXT(INT(ABS(C3)*10)-INT(ABS(C3))*10,"[dbnum2]")&"角",IF(INT(ABS(C3))=ABS(C3),,IF(ABS(C3)<0.1,,"零")))&IF(ROUND(ABS(C3)*100-INT(ABS(C3)*10)*10,),TEXT(ROUND(ABS(C3)*100-INT(ABS(C3)*10)*10,),"[dbnum2]")&"分","整")))