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

[µo°Ý] ±qA¦C¨ìB¦C¨ú±o¥|­Ó¦rµM«á¥[¾îºb°µ¨ìÀɮפ¤¥h?

[µo°Ý] ±qA¦C¨ìB¦C¨ú±o¥|­Ó¦rµM«á¥[¾îºb°µ¨ìÀɮפ¤¥h?

¾Ç©f¤S¨Ó³Â·Ð¤j®a¤F

½Ð«Ó­ô/¬ü¤kª©¥D «Ó­ô/¬ü¤k¾Çªø¸ò¾Ç©j

À°¦£¾Ç©f§¹¦¨

ÁÂÁ¤F

metrostar306.rar (2.13 KB)

¤èªk¤@¡G¥Î¸ê®Æ­åªR¤ÀÄæ«á¦A¥Î¤½¦¡²Õ¦X
¤èªk¤G¡G©w¸q¦WºÙ metrostar306.rar (2.38 KB)
¤èªk¤T¡G¼gvba

ªþ¥óªö¤èªk¤G¡C

TOP

¥ª¨ì¥k=REPLACE(REPLACE(REPLACE(A1,5,0,"-"),10,0,"-"),15,0,"-")
¥k¨ì¥ª=REPLACE(REPLACE(REPLACE(A1,5-(16-LEN(A1)),0,"-"),10-(16-LEN(A1)),0,"-"),15-(16-LEN(A1)),0,"-")
¸É¨¬ 0 =REPLACE(REPLACE(REPLACE(A1,5,0,"-"),10,0,"-"),15,0,"-")&REPT("0",16-LEN(A1))

TOP

楼¥Dªº问题还­n进¤@¨B说©ú¡G¦r²Å¦êªº长«×¦³无规©w¡A¦pªG¬O¤£©w长ªº¦r²Å¦ê¡A¥Î纯ºé¨ç数ªº¤èªk¡A¯uªº¤Ó§x难¤F¡C

TOP

¦hÁ«ӭôª©¥D¸ò«Ó­ô¾Çªø
±z­Ì¨â¦ì´£¨Ñªº¤èªk³£§¹¥þ¥i¥H¹F¨ì­C
¾Ç©f«D±`·P°Ê©O
±z­Ì¨â¦ì¯u¬O¤Ó±j¤Ó±j¤F
·PÁ±z­Ì¨Ã¯¬¶P±z­Ì
©¯ºÖ¦n¹B¥Ã»·­°Á{±z­Ì¨â¨­¤W

TOP

        ÀR«ä¦Û¦b : ¥Í®ð¡A´N¬O®³§O¤Hªº¹L¿ù¨ÓÃg»@¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD