æ åµä¸ï¼æ®éæ°æ®ï¼å¨B1使ç¨å ¬å¼=RIGHT(A1,LEN(A1)-FIND("/",A1))&"/"&LEFT(A1,FIND("/",A1)-1)
æ åµäºï¼æ°æ®æ¯æ¥æï¼æ¯å¦â8/12âæ¯â8æ12æ¥âï¼å°åå æ ¼æ ¼å¼èªå®ä¹ä¸ºâd/mâå³å¯ï¼ä¹å¯ä»¥å¨B1使ç¨å ¬å¼=TEXT(A1,"d/m")