第1个回答 推荐于2017-12-15
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]"))
下拉公式填充。看你的需求选某一公式。本回答被网友采纳