excel中第一个字母如何小写

1.我想请教在一张excel表格中,一个单元格输入小写的数字金额,另一单

设A列为小写数字金额，在B列复制以下公式并下拉：

=IF(A1=0,"",IF(ABS(A1)<1,"",TEXT(TRUNC(ABS(A1)),"[DBNum2]"）&"元"）&IF(RIGHT(TRUNC(A1*100),2)*1=0,IF(ABS(A1)<0.01，""，"整"），IF(ABS(A1)<0.1,"",TEXT(RIGHT(TRUNC(A1*10)),"[dbnum2]"))&IF(RIGHT(TRUNC(A1*10))*1=0，""，"角"）&IF(RIGHT(TRUNC(A1*100))*1=0，"整"，TEXT(RIGHT(TRUNC(A1*100)),"[dbnum2]"）&"分"）））