Excel年月日自动分列的问题
发布网友
共4个回答
热心网友
B1 =YEAR(A1)&"年"
C1 =TEXT(MONTH(A1),"00月")
D1 =TEXT(DAY(A1),"00日")
热心网友
请验证，都是两位数显示的，且后面有月、日
=YEAR(A1)&"年"
=RIGHT("0"&MONTH(A1)&"月",3)
=RIGHT("0"&DAY(A1)&"日",3)
热心网友
B列
=YEAR(A1)
C列
=MONTH(A1)
D列
=DAY(A1)
热心网友
B1 =RIGHT(YEAR(A1),2)&"年"
C1 =TEXT(MONTH(A1),"00月")
D1 =TEXT(DAY(A1),"00日")
