Excel之Text函数
=TEXT(A3,"[DBNUM1]")
=TEXT(A4,"[DBNUM1]")
=TEXT(A5,"[DBNUM1]")
=TEXT(A6,"[DBNUM1]0")
=TEXT(A7,"[DBNUM1]0")
=TEXT(A8,"[DBNUM1]0")
=TEXT(A9,"[DBNUM2]")
=TEXT(A10,"[DBNUM2]")
=TEXT(A11,"[DBNUM2]")
=TEXT(A12,"[DBNUM2]0")
=TEXT(A13,"[DBNUM2]0")
=TEXT(A14,"[DBNUM2]0")
=TEXT(A15,"[DBNUM3]")
=TEXT(A16,"[DBNUM3]")
=TEXT(A17,"[DBNUM3]")
=TEXT(A18,"[DBNUM3]0")
=TEXT(A19,"[DBNUM3]0")
=TEXT(A20,"[DBNUM3]0")
=TEXT(A21,"##.##")
=TEXT(A22,"##.#0")
=TEXT(A23,"##.#0")
=TEXT(A24,"##.#0％")
=TEXT(A25,"#??/???")
=TEXT(A26,"￥#,##0")
=TEXT(A27,"YYYY")
=TEXT(A28,"YY")
=TEXT(A29,"MM")
=TEXT(A30,"DD")
=TEXT(A31,"DDD")
=TEXT(A32,"DDDD")
=TEXT(A33,"MMM")
=TEXT(A34,"MMMM")
=TEXT(A35,"aaaa")
=TEXT(A36,"aaa")
=TEXT(A37,"aa")
=TEXT(A38,"hh")
=TEXT(A39,"hh:mm")
=TEXT(A40,"hh:mm:ss")
08:26:00 AM
=TEXT(A41,"hh:mm AM/PM")
已投稿到：
以上网友发言只代表其个人观点，不代表新浪网的观点或立场。本视频由声明原创。请使用支持脚本的浏览器！
你访问的博客设置了访问权限，你暂时不能查看。博主可在此
不如去逛逛吧。
网易公司版权所有&&&请使用支持脚本的浏览器！
你访问的博客设置了访问权限，你暂时不能查看。博主可在此
不如去逛逛吧。
网易公司版权所有&&&}