胡半仙:
设数据在a1格,公式如下=if(iserror(find(".",a1)),numberstring(int(a1),2)&"元整",if(iserror(numberstring(mID(a1,find(".",a1)+2,1),2)),numberstring(int(a1),2)&"元"&numberstring(mID(a1,find(".",a1)+1,1),2)&"角整",numberstring(int(a1),2)&"元"&numberstring(mID(a1,find("."....