角分
金额大小写自动转换示例及公式
佰拾元角分大小写转换公式如下：125502300012200可以直接复制以上公式来用，其中红的B7就是小写的单元格477.5肆佰柒拾柒元伍角整公式：=IF(ISTEXT(B7),"",TEXT(INT(B7),"[dbnum2]")&"元"&IF(INT(B7*10)-INT(B7)*10=0,"",TEXT(INT(B7*10)-INT(B7)*10,"[dbnum2]")&a...
用于将数字换汉字大写数字的函数
用于将数字换汉字大写数字的函数Function zhh(mrmbze)Dim S_1 As StringDim S_2 As StringDim S_4 As StringDim s_5 As StringDim S_6 As StringDim S_7 As StringDim I As IntegerDim tn As SingleS_1 = "零壹贰叁肆伍陆柒捌玖"S_2 = "仟佰拾万仟佰...
