大写金额转换规则
永利文化传媒
2024-11-16 12:02:45
最佳回答
如果你的金额在a1单元格,=if(a1=0,"",concatenate(if(int(a1)=0,"",text(int(a1),"人民币[dbnum2][$-804]g/通用格式元")),if(int(mid(right(fixed(a1,2,1),2),1,1))=0,if(int(mid(right(fixed(a1,2,1),1),1,1))=0,"",if(int(a1)=0,"","零")),text(int(mid(right(fixed(a1,2,1),2),1,1)),"[dbnum2][$-804]g/通用格式角")),if(int(mid(right(fixed(a1,2,1),1),1,1))=0,"整",text(int(mid(right(fixed(a1,2,1),1),1,1)),"[dbnum2][$-804]g/通用格式分"))))复制上去就可以了 20210311