excel中怎么样把带小数点的数字变成会计用的%E

Question

比如：123.12变成壹佰贰拾叁元壹角贰分

Answer 1

选定需要改变的单元格，右键单击，选单元格格式设置，选数字，选特殊，选中文大写数字，这样，你输入123.12就能显示大写的了，打印时候也是显示大写。

Answer 2

网上大把自定义函数

Function DX(n)
DX = Replace(Application.Text(Round(n + 0.00000001, 2), "[DBnum2]"), ".", "元")
DX = IIf(Left(Right(DX, 3), 1) = "元", Left(DX, Len(DX) - 1) & "角" & Right(DX, 1) & "分", IIf(Left(Right(DX, 2), 1) = "元", DX & "角整", IIf(DX = "零", "", DX & "元整")))
DX = Replace(Replace(Replace(Replace(DX, "零元零角", ""), "零元", ""), "零角", "零"), "-", "负")
End Function

Answer 3

假设你得小写金额在A1,则你在B1中输入=IF((A1-INT(A1))=0,TEXT(A1,"[DBNUM2]")&"元整",IF(INT(A1*10)-A1*10=0,TEXT(INT(A1),"[DBNUM2]")&"元"&TEXT((INT(A1*10)-INT(A1)*10),"[DBNUM2]")&"角整",TEXT(INT(A1),"[DBNUM2]")&"元"&IF(INT(A1*10)-INT(A1)*10=0,"零",TEXT(INT(A1*10)-INT(A1)*10,"[DBNUM2]")&"角")&TEXT(RIGHT(A1,1),"[DBNUM2]")&"分"))就可以了

Answer 4

选定需要转换的单元格—>右击—>单元格格式—>数字—>特殊—>选中文大写数字—>确定 后就OK了