金额大写转换函数 CNMONEY()，建议可以保留小数点后4位，格式化到厘

A3 为数字单元格，曲线救国吧，分会四舍五入，自己考虑吧

CONCATENATE(CNMONEY(round(A3,4)),
if(left(right(round(A3,4),2),1)=0,"零毫",
if(left(right(round(A3,4),2),1)=1,"壹毫",
if(left(right(round(A3,4),2),1)=2,"贰毫",
if(left(right(round(A3,4),2),1)=3,"叁毫",
if(left(right(round(A3,4),2),1)=4,"肆毫",
if(left(right(round(A3,4),2),1)=5,"伍毫",
if(left(right(round(A3,4),2),1)=6,"陆毫",
if(left(right(round(A3,4),2),1)=7,"柒毫",
if(left(right(round(A3,4),2),1)=8,"捌毫","玖毫",))))))))),
if(right(round(A3,4),1)=0,"零厘",
if(right(round(A3,4),1)=1,"壹厘",
if(right(round(A3,4),1)=2,"贰厘",
if(right(round(A3,4),1)=3,"叁厘",
if(right(round(A3,4),1)=4,"肆厘",
if(right(round(A3,4),1)=5,"伍厘",
if(right(round(A3,4),1)=6,"陆厘",
if(right(round(A3,4),1)=7,"柒厘",
if(right(round(A3,4),1)=8,"捌厘","玖厘",))))))))))

哈哈，是有点曲线的，我写了个js，然后不知道怎么调用

金税系统单价可以支持到16位，最后的金额和税额不还是2位？
金额到厘现实工作和生活中有意义吗？有差额要想怎么去统一，而不是金额精确到厘。单价和数量可以两位或者以上，最后的金额不可能2位以上。财务记账只记到分，没有再往下记的。