本帖最后由 pobopo 于 2010-10-19 01:15 编辑
怎么将“01234”转换为"O一二三四"
----此处只转换前5位,多余的忽略。
if(mid($MF(A1)$,1,1)="1","一",if(mid($MF(A1)$,1,1)="2","二",if(mid($MF(A1)$,1,1)="3","三",if(mid($MF(A1)$,1,1)="4","四",if(mid($MF(A1)$,1,1)="5","五",if(mid($MF(A1)$,1,1)="6","六",if(mid($MF(A1)$,1,1)="7","七",if(mid($MF(A1)$,1,1)="8","八",if(mid($MF(A1)$,1,1)="9","九",if(mid($MF(A1)$,1,1)="0","〇"))))))))))&if(mid($MF(A1)$,2,1)="1","一",if(mid($MF(A1)$,2,1)="2","二",if(mid($MF(A1)$,2,1)="3","三",if(mid($MF(A1)$,2,1)="4","四",if(mid($MF(A1)$,2,1)="5","五",if(mid($MF(A1)$,2,1)="6","六",if(mid($MF(A1)$,2,1)="7","七",if(mid($MF(A1)$,2,1)="8","八",if(mid($MF(A1)$,2,1)="9","九",if(mid($MF(A1)$,2,1)="0","〇"))))))))))&if(mid($MF(A1)$,3,1)="1","一",if(mid($MF(A1)$,3,1)="2","二",if(mid($MF(A1)$,3,1)="3","三",if(mid($MF(A1)$,3,1)="4","四",if(mid($MF(A1)$,3,1)="5","五",if(mid($MF(A1)$,3,1)="6","六",if(mid($MF(A1)$,3,1)="7","七",if(mid($MF(A1)$,3,1)="8","八",if(mid($MF(A1)$,3,1)="9","九",if(mid($MF(A1)$,3,1)="0","〇"))))))))))&if(mid($MF(A1)$,4,1)="1","一",if(mid($MF(A1)$,4,1)="2","二",if(mid($MF(A1)$,4,1)="3","三",if(mid($MF(A1)$,4,1)="4","四",if(mid($MF(A1)$,4,1)="5","五",if(mid($MF(A1)$,4,1)="6","六",if(mid($MF(A1)$,4,1)="7","七",if(mid($MF(A1)$,4,1)="8","八",if(mid($MF(A1)$,4,1)="9","九",if(mid($MF(A1)$,4,1)="0","〇"))))))))))&if(mid($MF(A1)$,5,1)="1","一",if(mid($MF(A1)$,5,1)="2","二",if(mid($MF(A1)$,5,1)="3","三",if(mid($MF(A1)$,5,1)="4","四",if(mid($MF(A1)$,5,1)="5","五",if(mid($MF(A1)$,5,1)="6","六",if(mid($MF(A1)$,5,1)="7","七",if(mid($MF(A1)$,5,1)="8","八",if(mid($MF(A1)$,5,1)="9","九",if(mid($MF(A1)$,5,1)="0","〇")))))))))) |