第1个回答 2011-04-11
()仟()佰()拾()万()仟()佰()拾()元()角()分
10个括号从左到右内依次为:
=IF(LEN(TEXT(A1*100,"[dbnum2]0"))>9,MID(TEXT(A1*100,"[dbnum2]0"),LEN(TEXT(A1*100,"[dbnum2]0"))-9,1),"/")
=IF(LEN(TEXT(A1*100,"[dbnum2]0"))>8,MID(TEXT(A1*100,"[dbnum2]0"),LEN(TEXT(A1*100,"[dbnum2]0"))-8,1),"/")
=IF(LEN(TEXT(A1*100,"[dbnum2]0"))>7,MID(TEXT(A1*100,"[dbnum2]0"),LEN(TEXT(A1*100,"[dbnum2]0"))-7,1),"/")
。
。
。
=IF(LEN(TEXT(A1*100,"[dbnum2]0"))>2,MID(TEXT(A1*100,"[dbnum2]0"),LEN(TEXT(A1*100,"[dbnum2]0"))-2,1),"/")
=IF(LEN(TEXT(A1*100,"[dbnum2]0"))>1,MID(TEXT(A1*100,"[dbnum2]0"),LEN(TEXT(A1*100,"[dbnum2]0"))-1,1),"/")
=IF(LEN(TEXT(A1*100,"[dbnum2]0"))>0,MID(TEXT(A1*100,"[dbnum2]0"),LEN(TEXT(A1*100,"[dbnum2]0")),1),"/")
第3个回答 2011-04-11
=TEXT(SUBSTITUTE(A1,".",""),"[dbnum2]0")