[算表] 日期問題
軟體: office excel
版本: 2010
想請問
現在有一串時間 A欄，想變成B欄的形式，
不知道有什麼公式可以寫@@?
麻煩各位大大了，謝謝 :)"
A B
1992412 1992/04/12
199272 1992/07/02
1992920 1992/09/20
19931225 1993/12/25
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 61.56.4.232
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1423733937.A.247.html
→
02/12 17:52, , 1F
02/12 17:52, 1F
→
02/12 17:52, , 2F
02/12 17:52, 2F
→
02/12 17:55, , 3F
02/12 17:55, 3F
→
02/12 17:55, , 4F
02/12 17:55, 4F
→
02/13 07:53, , 5F
02/13 07:53, 5F
→
02/13 07:54, , 6F
02/13 07:54, 6F
→
02/13 07:54, , 7F
02/13 07:54, 7F
→
02/13 08:09, , 8F
02/13 08:09, 8F
→
02/13 08:10, , 9F
02/13 08:10, 9F
→
02/13 09:37, , 10F
02/13 09:37, 10F
→
02/13 09:39, , 11F
02/13 09:39, 11F
→
02/13 09:42, , 12F
02/13 09:42, 12F
→
02/13 10:00, , 13F
02/13 10:00, 13F
→
02/13 10:00, , 14F
02/13 10:00, 14F
Office 近期熱門文章
PTT數位生活區 即時熱門文章