ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

¸ê®Æ±Æ§Ç

¸ê®Æ±Æ§Ç

§Ú¦³¤@°ï¼Æ¾Ú®æ¦¡¦p¤U
1-36
1-40
2-6
3-9
4-6
1-41
2-22
3-1
½Ð°Ý§Ú­n«ç»ò°µ¤~¯àÅý¥L±Æ¦¨
1-36
1-40
1-41
2-6
2-22
3-1
3-9
4-6

¥H¤Wªº°ÝÃD,§Ú·Q¦h°Ý¤@¤U
§Ú«á¨Ó·Q¥Î¤å¦rÂର¼Æ¦rªº¤èªk¨Ó±Æ§Ç
¦ý¬O«Ü©_©Çªº¬O1-36´N¬OÂण¦¨¼Æ¦r
³o¤S«ç»ò¸Ñ??

TOP

¥Î¸ê®Æ­åªR=>¥H¤À¹j²Å¸¹"-",­åªR¬°¨âÄæ¦A¥HAÄ欰¥DBÄ欰¦¸±Æ§Ç
c1=A1&"-"&B1

?-??¬°EXCEL黙»{ªº¤é´Á®æ¦¡,¥[¤F--·|±o¨ì¤@­Ó¤é´Á¹ïÀ³ªº§Ç¦C­È,¦ý¤£¦X¥G®æ¦¡¦p1-36
¤é´Á¶W¹L31·|¥X¿ù
=DATE(2012,LEFT(A1),RIGHT(A1,2))¥iÂର¤é´Á,¦ý¦b³o¸Ì¤£¯à¨Ì¦¹±Æ§Ç¦]¤é´Á¤j©ó31
·|¶i¦ì¨ì¤ë¦p1-36µ¥©ó2-5 ·|¤j©ó2-3

TOP

        ÀR«ä¦Û¦b : ¤H¥Í¤£¤@©w²y²y¬O¦n²y¡A¦ý¬O¦³¾ú½mªº±j¥´ªÌ¡AÀH®É³£¥i¥H´§´Î¡C
ªð¦^¦Cªí ¤W¤@¥DÃD