excel数字不能正确转换大写金额答:假如你的“123”在B1单元格,在另一个单元格输入以下公式:="大写金额:"&IF(TRIM(B1)="","",IF(B1=0,"","人民币"&IF(B1<0,"负",)&IF(INT(B1),TEXT(INT(ABS(B1)),"[dbnum2]")&"元",)&IF(INT(ABS(B1)*10)-INT(ABS(B1))*10,TEXT(INT(ABS(B1)*10)-INT(ABS(B1))...
...输入123.45,输出壹佰贰拾叁元肆角五分,输入123,输出壹佰贰拾_百度...答:/** * 数字金额大写转换,思想先写个完整的然后将如零拾替换成零 * 要用到正则表达式 */ public static String digitUppercase(double n){ String fraction[] = {"角", "分"}; String digit[] = { "零", "壹", "贰", "叁", "肆", "伍", "陆", "柒", "...