Excel之Text函数

原值结果公式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 1=TEXT(A15,"[DBNUM3]") 101 十=TEXT(A16,"[DBNUM3]")111 十 1=TEXT(A17,"[DBNUM3]") 1 1=TEXT(A18,"[DBNUM3]0")101 0=TEXT(A19,"[DBNUM3]0") 111 1=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")2006-7-31MON=TEXT(A31,"DDD") 2006-7-31Mondy=TEXT(A32,"DDDD")2006-7-31Jul=TEXT(A33,"MMM") 2006-7-31July=TEXT(A34,"MMMM")2007-8-9星期四=TEXT(A35,"aaaa") 2007-8-9四=TEXT(A36,"aaa") 2007-8-9aa=TEXT(A37,"aa") 8:2608=TEXT(A38,"hh") 8:2608:26=TEXT(A39,"hh:mm") 8:2608:26:00=TEXT(A40,"hh:mm:ss") 8:2608:26:00 AM=TEXT(A41,"hh:mm AM/PM")