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

[µo°Ý] ¤é´Á¥[´îªº°ÝÃD

[µo°Ý] ¤é´Á¥[´îªº°ÝÃD

¦U¦ì«e½ú¦n¡A¤p§Ì¦b°µ¤@­Óªíªº®É­Ô¡A·Q­nÅýA1¿é¤J¤é´Á¡AB1¡BC1´N¦Û°Ê¸òµÛ³s°Ê¡A¼Ë¦¡¦p¤U¡G

         A           B          C
  1  102/03   102/04   102/05
  2

§Ú¦bB1¿é¤J¤½¦¡¡G="102/"&RIGHT(A1,2)+1
¥i¬OÅã¥Ü¥X¨Óªº­È«o¬O102/4¡A½Ð°Ý¦³¤°»ò¤èªkÅý¥LÅã¥Ü¦¨102/04¶Ü¡H
ÁÂÁÂ~

¦^´_ 1# owen06
  1. ="102/"&TEXT(RIGHT(A2,2)+1,"00")
½Æ»s¥N½X

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2013-7-17 14:47 ½s¿è

¦^´_ 1# owen06
½Ð°Ñ¦Ò
="102/"&TEXT(RIGHT(A1,2)+1,"00")
Sorry! ­«½Æ¤F¡I(¦^ÂЮɥ¼Åã¥ÜBodhidharma¤j¤w¸Ñµª¤F)

TOP

¥i¥H¤F¡A«D±`·PÁÂBodhidharma¡Bp212 ¤G¦ì°ª¤â¡AÁÂÁÂ~
¹Lµ{¤¤§Ú¤]¸Õ¹L¥Îtext¡A¦ý¦]¬°¤£¤Ó¼ô±xªºÃö«Y¡A©Ò¥H¤£ª¾¹D­n¥Î"00"¡K
·PÁ§A­Ì~

TOP

¦A½Ð±Ð¤@¤U¡A¦]¬°§Ú¹ê»Ú¥h°µ¤§«á¡Aµo²{·|¦³¤@­Ó°ÝÃD¡A´N¬O¨ì³Ì«á·|Åܦ¨102/13¡A
©Ò¥HÁÙ¬O¦A½Ð±Ð¦U¦ì¡A«ç¼Ëªº¥¿³W°µªk¡A¤~¯àÅýA1¿é¤J¤é´Á«á¡AB1¡BC1´N·|¦Û°Ê¸õ¤U¤G­Ó¤ë¡A
¥B·íA1¬°102/11®É¡AC1¯à¦Û°ÊÅܬ°103/01¡AÁÂÁÂ~

TOP

·Q¤F¦n¤[²×©ó¸Ñ¥X¨Ó¤F¡A¤À¨É¤@¤U
=IF(TEXT(RIGHT(A1,2),"00")="12",TEXT(LEFT(A1,3)+1,"000")&"/"&TEXT(RIGHT(A1,2)-11,"00"),TEXT(LEFT(A1,3),"000")&"/"&TEXT(RIGHT(A1,2)+1,"00"))
¦p¦¹¤@¨Ó´N¥i¥H¤@ª½¥¿½Tªº©µÄò¤U¥h¤F

TOP

¦^´_ 6# owen06
½Ð°Ñ¦Ò

Fig.JPG (70.72 KB)

Fig.JPG

TOP

¦^´_ 7# p212

¤ÓÁÂÁ¤F¡A¤SÅý§Ú¾Ç¨ì¦n¦hªF¦è¡A§Ú¬Q¤Ñ¬ÝµÛexcel¸Ìªºdate¨ç¼Æ»¡©ú¡A¬Ý¤F¦Ñ¥b¤Ñ«o¤£ª¾¹D¸Ó«ç»ò¨Ï¥Î¡A
­ì¨ÓÁÙ­n·f°ttext¨Ó¨Ï¥Î¡A¤£¹Ltext«á­±ªº¨º­Ó"xx"ªº¥Îªk§ÚÁÙ­n¦A¦hªá®É¶¡¬ã¨s¤@¤U¡A
¬Ý¤F§Aªº½d¨Ò¤§«á¡A¹ï³o¤G­Ó¨ç¼ÆÆ[©À²M·¡¦h¤F¡C

§Ú­è¸ÕµÛ¥Î§A±Ðªºµ{¦¡ÅÞ¿è¤U¥h¼g¡A
=TEXT(DATE(LEFT(A1,3)+1911,RIGHT(A1,2)+1,1),"ee/mm")

³o¼Ë´N¥i¥H¦ba1¿é¤J¤é´Á¡A«á­±ªº¤é´Á´N·|¥þ³¡¦Û°Ê±a¤J¡AÁÂÁ§AÅo¡I

TOP

        ÀR«ä¦Û¦b : ¡i¥Í©R¦b©I§l¶¡¡j¦òªû»¡¡G¡u¥Í©R¦b©I§l¶¡¡C¡v¤HµLªkºÞ¦í¦Û¤vªº¥Í©R¡A§óµLªk¾×¦í¦º´Á¡AÅý¦Û¤v¥Ã¦í¤H¶¡¡C¬JµM¥Í©R¥h¨Ó³o»òµL±`¡A§Ú­Ì§óÀ³¸Ó¦n¦n¦a·R±¤¥¦¡B§Q¥Î¥¦¡B¥R¹ê¥¦¡AÅý³oµL±`¡BÄ_¶Qªº¥Í©R¡A´²µo¥¦¯uµ½¬üªº¥ú½÷¡A¬M·Ó¥X¥Í©R¯u¥¿ªº»ù­È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD