多少?这对编员率下强买写函数有用!
我已经帮你检富落叶用函数实现了,费了我不少脑细胞,你试试看看是否满意。比如你的A1格输入10000急原贵气继天00.01,要在B1格把它转换为中文大写,你只需要在B1复制以下函数那造:
=TEXT(TRUNC(A1),"[Dbnum2]")&"圆"&IF(ROUND((A1-TRUNC(A1))*100,1)<>0,IF(LEN(ROUND((A1-TRUNC(A1))*100,1))=1,"零角"&TEXT(ROUND((A1-TRUNC(A1))*100,1),"[Dbnum2]")&"分",TEXT((ROUND((A1-TRUNC(A1))*100,1)-MOD(ROUND((A1-TRUNC(A1))*100,1),10)程良设科担翻种饭交精)/10,"[Dbnum2]")&"角"&TEXT(MOD(ROUND((A1-TRUNC(A1))*100,1),10),"[Dbnum2]")&"分"),"零角零分")