(空白標題)
(若是和其他不同軟體互動之問題 請記得一併填寫)
您所使用的軟體為:MS EXCEL
版本:2003
問題:
A1 97/01/29
B1 28
C1 =A1-B1+4017
D1 =CONCATENATE(YEAR(C1)-1911,"/",MONTH(C1),"/",DAY(C1))
D1會顯示97/1/2,但是我想要讓它顯示為97/01/02,
不知道要如何做呢?
--
D1是爬文後解決了民國年的問題Q_Q
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 61.223.3.200
→
01/29 11:43, , 1F
01/29 11:43, 1F
→
01/29 12:01, , 2F
01/29 12:01, 2F
→
01/29 12:12, , 3F
01/29 12:12, 3F
→
01/29 12:14, , 4F
01/29 12:14, 4F
→
01/29 12:24, , 5F
01/29 12:24, 5F
→
01/29 12:25, , 6F
01/29 12:25, 6F
※ 編輯: Vinci822 來自: 61.223.3.200 (01/29 14:38)
→
01/29 15:18, , 7F
01/29 15:18, 7F
推
01/29 18:42, , 8F
01/29 18:42, 8F
推
01/29 18:57, , 9F
01/29 18:57, 9F
→
01/30 00:32, , 10F
01/30 00:32, 10F
討論串 (同標題文章)