請問在EXCEL中日期設成1050322要如何快速讓整批這樣的日期數字變成105.03.22?
回答 (3)
2016-03-23 9:43 am
=SUBSTITUTE(TEXT(A1,"0-00-00"),"-",".")
2016-03-22 5:14 am
=LEFT(A2,3)&"."&MID(A2,4,2)&"."&RIGHT(A2,2)
2016-03-22 12:28 am
用鍵盤輸入最快
收錄日期: 2021-05-04 02:06:07
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20160321162750AAlktmR