就是在电子表格中，将日期生成以下的单号，将在大写金额前加人民币

Question

以插入公式=TEXT(A2,"!N!0:emmdd!0!0!1")或="NO:"&TEXT(G3,"emmdd")&"001"
怎么样使，底下的单号能从001 002 003自动排的

还有就是在大写合计金额以插入公式=SUBSTITUTE(SUBSTITUTE(TEXT(TRUNC(FIXED(F17)),"[dbnum2]G/通用格式元;负[dbnum2]G/通用格式元;"&IF(F17>-0.5%,,"负"))&TEXT(RIGHT(FIXED(F17),2),"[dbnum2]0角0分;;"&IF(ABS(F17)>1%,"整",)),"零角",IF(ABS(F17)<1,,"零")),"零分","整")
如何前面加上人民币

Answer 1

G2单元格写入公式
=TEXT(G3,"!N!O:emmdd")&TEXT(ROW(A18)/18,"000")
或
="NO:"&TEXT(G3,"emmdd")&TEXT(ROW(A18)/18,"000")
再复制G2单元格粘帖到G20,G38.....单元格

=IF(F17=0,"","人民币:"&SUBSTITUTE(SUBSTITUTE(TEXT(TRUNC(FIXED(F17)),"[dbnum2]G/通用格式元;负[dbnum2]G/通用格式元;"&IF(F17>-0.5%,,"负"))&TEXT(RIGHT(FIXED(F17),2),"[dbnum2]0角0分;;"&IF(ABS(F17)>1%,"整",)),"零角",IF(ABS(F17)<1,,"零")),"零分","整"))

或

=IF(F17=0,"","人民币:"&SUBSTITUTE(SUBSTITUTE(IF(-RMB(F17),IF(F17>0,,"负")&TEXT(INT(ABS(F17)+0.5%),"[dbnum2]G/通用格式元;;")&TEXT(RIGHT(RMB(F17,2),2),"[dbnum2]0角0分;;整"),),"零角",IF(F17^2<1,,"零")),"零分","整"))