第2个回答 2014-09-22
将345.67填在一个单元格A1里,让7个横向连续的单元格的数据自动填写成 (空)(空) 3 4 5 6 7.有千位的时候第二个空就是千位的数字:
假设:你将数字输入A1单元格里,那么:F6-L6的公式依次为:
F6=IF(ISERROR(RIGHT(LEFT(A1*100,(LENB(A1*100))-6),1)),"",RIGHT(LEFT(A1*100,(LENB(A1*100))-6),1))
G6=IF(ISERROR(RIGHT(LEFT(A1*100,(LENB(A1*100))-5),1)),"",RIGHT(LEFT(A1*100,(LENB(A1*100))-5),1))
H6=IF(ISERROR(RIGHT(LEFT(A1*100,(LENB(A1*100))-4),1)),"",RIGHT(LEFT(A1*100,(LENB(A1*100))-4),1))
I6=IF(ISERROR(RIGHT(LEFT(A1*100,(LENB(A1*100))-3),1)),"",RIGHT(LEFT(A1*100,(LENB(A1*100))-3),1))
J6=IF(ISERROR(RIGHT(LEFT(A1*100,(LENB(A1*100))-2),1)),"",RIGHT(LEFT(A1*100,(LENB(A1*100))-2),1))
K6=LEFT(RIGHT(A1*100,2),1)
L6=RIGHT(RIGHT(A1*100,2),1)
第3个回答 2014-09-22
=FLOOR(A1,10)/10(舍个位)
=FLOOR(A1,100)/10+MOD(A1,10)(舍十位)
=FLOOR(A1,1000)/10+MOD(A1,100)(舍百位)
=MOD(A1,1000)(舍千位)
五位以上继续加0就行了