ããæ¹æ³ä¸ï¼ï¼ååæ³ï¼éä¸æ¥æââæ°æ®âé项å¡âååâä¸ä¸æ¥âä¸ä¸æ¥âéæ©âæ¥æââå®æï¼æ¤æ¶â19880303âå为â1988/3/3âï¼é¼ æ å³é®â设置åå
æ ¼æ ¼å¼ââæ°åâé项å¡âèªå®ä¹âå°æ ¼å¼å®ä¹ä¸ºâe/mm/ddâï¼
ããæ¹æ³äºï¼ï¼
å
¬å¼æ³ï¼å设æ¥æå¨A1å¼å§ï¼å
¬å¼=text(a1,"0!/00!/00")ï¼å¦æä¸éè¦ç»æåä¸æ¥æ计ç®ï¼æ¤å
¬å¼å³å¯æ»¡è¶³è¦æ±ï¼å¦æéè¦åä¸æ¥æ计ç®ï¼å
¬å¼=text(text(a1,"0-00-00"),"e/mm/dd")ã