第1个回答 2019-05-24
11要显示什么,一十一,还是一一,还是其他?
=text(row(A1),"[dbnum1]")
=text(row(A1),"0[dbnum1]")
=substitute(text(row(A1),"[dbnum1]"),"一十","十")
=IF(ROW(A1)<20,SUBSTITUTE(TEXT(ROW(A1),"[dbnum1]"),"一十","十"),TEXT(ROW(A1),"[dbnum1]"))
下拉公式填充。看你的需求选某一公式。
第2个回答 2019-05-11
11要显示什么,一十一,还是一一,还是其他?
=text(row(A1),"[dbnum1]")
=text(row(A1),"0[dbnum1]")
=substitute(text(row(A1),"[dbnum1]"),"一十","十")
=IF(ROW(A1)<20,SUBSTITUTE(TEXT(ROW(A1),"[dbnum1]"),"一十","十"),TEXT(ROW(A1),"[dbnum1]"))
下拉公式填充。看你的需求选某一公式。