人民币在excel如何打出来

1.用Excel电子表格如何显示中文大写金额呢

举例：A1是人民币金额数字，在你要显示的单元格内输入 =IF(A1<0，"负"，"")&IF(TRUNC(A1)=A1,TEXT(IF(A1<0,-A1,A1),"[DBNum2]"）&"元整"，IF(TRUNC(A1*10)=A1*10,TEXT(TRUNC(IF(A1<0,-A1,A1)),"[DBNum2]"）&"元"&TEXT(RIGHT(A1),"[DBNum2]"）&"角整"，TEXT(TRUNC(IF(A1<0,-A1,A1)),"[DBNum2]"）&"元"&IF(ISNUMBER(FIND(".0",A1)），"零"，TEXT(LEFT(RIGHT(A1,2)),"[DBNum2]"）&"角"）&TEXT(RIGHT(A1),"[DBNum2]"）&"分"））随着A1的数值变动，单元格内会显示A1的人民币大写金额，“角”“分”都可以显示。