办公族

办公族
日常办公族工作中所需技巧

Excel中利用text函数转换日期格式

1
单元格转化前函数
A22020/6/21=TEXT(A2,"yyyy-m-d")
A32020/6/22=TEXT(A3,"yyyy-mm-dd")
A42020/6/23=TEXT(A4,"yyyy-mm-dd")
A52020/6/24=TEXT(A5,"yyyy年mm月dd日")
A62020/6/25=TEXT(A6,"mmmm")
A72020/6/26=TEXT(A7,"mmm")
A82020/6/27=TEXT(A8,"ddd")
A92020/6/28=TEXT(A9,"dddd")
A102020/6/29=TEXT(A10,"aaaa")
A11
2020/7/1=TEXT(A11,"aaa")
A12
0:54:30=TEXT(A12,"h时mm分")
A13
0:54:30=TEXT(A13,"h时mm分ss秒")


转载请注明出处:办公族 » Excel中利用text函数转换日期格式
cache
Processed in 0.004210 Second.