有小数点的数字大写怎么写 比如123.45
发布网友
发布时间:2022-08-18 00:25
我来回答
共1个回答
热心网友
时间:2023-11-06 00:59
A1=数字
B1=SUBSTITUTE(IF(A1>=1,IF(A1>=0,"零",IF(A1>-1,"负零","负")))&TEXT(TRUNC(A1),"[dbnum1]g/通用格式;[dbnum1]g/通用格式;")&SUBSTITUTE(TEXT(RIGHT(A1,LEN(A1)-LEN(TRUNC(A1))),"点[dbnum1]g/通用格式;点[dbnum1]g/通用格式;"),"○.",),"○","零")