[算表] Excel:MDY日期格式,資料剖析
問: 將 09/01/2008 轉換成 2008/09/01
答: 資料剖析/日期/MDY
如此轉換成日期序列值後,再改數值格式。
若要輸入時即辨認為日期,
控制台/地區及語言選項/
地區選美國 或 自訂簡短日期樣式。
--------原文如下----------
作者: taihsin (一一一一一一一一一一一) 看板: Wanted
標題: [徵求] EXCEL強者
時間: Tue Sep 2 00:41:29 2008
徵求 利用EXCEL
將 09/01/2008 轉換成 2008/09/01 格式的方法
數值自訂那招無效=.=
google 奇摩知識 百度 都找過了
搞了好久 還是不知道怎麼用=.=||
完成後贈送P幣200 !!!
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 118.167.73.206
推
09/02 00:42,
09/02 00:42
→
09/02 00:42,
09/02 00:42
→
09/02 00:42,
09/02 00:42
推
09/02 00:42,
09/02 00:42
→
09/02 00:42,
09/02 00:42
推
09/02 00:42,
09/02 00:42
→
09/02 00:43,
09/02 00:43
→
09/02 00:43,
09/02 00:43
→
09/02 00:43,
09/02 00:43
→
09/02 00:43,
09/02 00:43
→
09/02 00:43,
09/02 00:43
→
09/02 00:44,
09/02 00:44
推
09/02 00:45,
09/02 00:45
推
09/02 00:46,
09/02 00:46
→
09/02 00:47,
09/02 00:47
→
09/02 00:48,
09/02 00:48
推
09/02 00:49,
09/02 00:49
→
09/02 00:55,
09/02 00:55
推
09/02 01:00,
09/02 01:00
推
09/02 01:03,
09/02 01:03
推
09/02 01:06,
09/02 01:06
→
09/02 01:06,
09/02 01:06
推
09/02 01:08,
09/02 01:08
→
09/02 01:08,
09/02 01:08
推
09/02 01:13,
09/02 01:13
推
09/02 04:50,
09/02 04:50
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 218.164.48.195
※ 編輯: JieJuen 來自: 218.164.48.195 (09/02 05:29)
推
09/02 05:31, , 1F
09/02 05:31, 1F
→
09/02 05:35, , 2F
09/02 05:35, 2F
→
09/02 05:42, , 3F
09/02 05:42, 3F
推
09/02 05:53, , 4F
09/02 05:53, 4F
→
02/20 02:41, , 5F
02/20 02:41, 5F
→
05/21 16:52, , 6F
05/21 16:52, 6F