您好,这边先建议您将金额转大小写的公式改为以下这个,经测试导入没问题了
=""&IF(TRIM(A1)="","",IF(A1=0,"",""&IF(A1<0,"负","")&IF(INT(A1),TEXT(INT(ABS(A1)),"[dbnum2]")&"圆",)&IF(INT(ABS(A1)*10)-INT(ABS(A1))*10,TEXT(INT(ABS(A1)*10)-INT(ABS(A1))*10,"[dbnum2]")&"角",IF(INT(ABS(A1))=ABS(A1),,IF(ABS(A1)<0.1,,"零")))&IF(ROUND(ABS(A1)*100-INT(ABS(A1)*10)*10,),TEXT(ROUND(ABS(A1)*100-INT(ABS(A1)*10)*10,),"[dbnum2]")&"分","整"))) |