|
| 原值 |
公式结果 |
公式 |
| 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.3 |
12.3 |
=TEXT(A21,"＃＃.＃＃") |
| 12.3 |
12.30 |
=TEXT(A22,"＃＃.＃0") |
| 12.35 |
12.35 |
=TEXT(A23,"＃＃.＃0") |
| 0.123 |
12.30% |
=TEXT(A24,"＃＃.＃0％") |
| 0.123 |
23/187 |
=TEXT(A25,"＃？？/？？？") |
| 1234 |
￥1,234 |
=TEXT(A26,"￥＃,＃＃0") |
| 2007-8-9 |
2007 |
=TEXT(A27,"YYYY") |
| 2007-8-9 |
07 |
=TEXT(A28,"YY") |
| 2007-8-9 |
08 |
=TEXT(A29,"MM") |
| 2007-8-9 |
09 |
=TEXT(A30,"DD") |
| 2007-8-9 |
星期四 |
=TEXT(A31,"aaaa") |
| 2007-8-9 |
四 |
=TEXT(A32,"aaa") |
| 2007-8-9 |
aa |
=TEXT(A33,"aa") |
| 8:26 |
08 |
=TEXT(A34,"hh") |
| 8:26 |
08:26 |
=TEXT(A35,"hh：mm") |
| 8:26 |
08:26:00 |
=TEXT(A36,"hh：mm：ss") |
|
