Excel 金额大写
完整代码:="金额合计(大写):"&IF((INT(OFFSET(INDIRECT(ADDRESS(ROW(),COLUMN())),-2,5)*10)-INT(OFFSET(INDIRECT(ADDRESS(ROW(),COLUMN())),-2,5))*10)=0,TEXT(INT(OFFSET(INDIRECT(ADDRESS(ROW(),COLUMN())),-2,5)),"[DBNum2
原创
2014-03-14 13:40:52 ·
816 阅读 ·
0 评论