原值公式结果公式
1一=TEXT(A3,"[DBNUM1]")
10一十=TEXT(A4,"[DBNUM1]")
11一十一=TEXT(A5,"[DBNUM1]")
1一=TEXT(A6,"[DBNUM1]0")
10一○=TEXT(A7,"[DBNUM1]0")
11一一=TEXT(A8,"[DBNUM1]0")
1壹=TEXT(A9,"[DBNUM2]")
10壹拾=TEXT(A10,"[DBNUM2]")
11壹拾壹=TEXT(A11,"[DBNUM2]")
1壹=TEXT(A12,"[DBNUM2]0")
10壹零=TEXT(A13,"[DBNUM2]0")
11壹壹=TEXT(A14,"[DBNUM2]0")
1１=TEXT(A15,"[DBNUM3]")
10１十=TEXT(A16,"[DBNUM3]")
11１十１=TEXT(A17,"[DBNUM3]")
1１=TEXT(A18,"[DBNUM3]0")
10１０=TEXT(A19,"[DBNUM3]0")
11１１=TEXT(A20,"[DBNUM3]0")
12.312.3=TEXT(A21,"＃＃.＃＃")
12.312.30=TEXT(A22,"＃＃.＃0")
12.3512.35=TEXT(A23,"＃＃.＃0")
0.12312.30%=TEXT(A24,"＃＃.＃0％")
0.12323/187=TEXT(A25,"＃？？/？？？")
1234￥1,234=TEXT(A26,"￥＃,＃＃0")
2007-8-92007=TEXT(A27,"YYYY")
2007-8-907=TEXT(A28,"YY")
2007-8-908=TEXT(A29,"MM")
2007-8-909=TEXT(A30,"DD")
2007-8-9星期四=TEXT(A31,"aaaa")
2007-8-9四=TEXT(A32,"aaa")
2007-8-9aa=TEXT(A33,"aa")
8:2608=TEXT(A34,"hh")
8:2608:26=TEXT(A35,"hh：mm")
8:2608:26:00=TEXT(A36,"hh：mm：ss")
本站仅提供存储服务，所有内容均由用户发布，如发现有害或侵权内容，请
点击举报。
