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

[µo°Ý] ½Ð°Ý¡G¦p¦ó±N¼Æ¦rÂà´«¦¨°ê¦r¡]¤w¸Ñ¨M¡^

[µo°Ý] ½Ð°Ý¡G¦p¦ó±N¼Æ¦rÂà´«¦¨°ê¦r¡]¤w¸Ñ¨M¡^

¥»©«³Ì«á¥Ñ onegirl0204 ©ó 2011-4-25 23:17 ½s¿è

¾Ç¥Í¯Z¯Å¥N¸¹§¡¬°¼Æ¦r¡A½Ð°Ý¸Ó¦p¦ó±N¼Æ¦rÂà´«¦¨°ê¦r¡H
¨Ò¦p¡G­ì¥»¢ÏÄ檺¾Ç¥Í¯Z¯Å¸ê®Æ³£¬O¥H¼Æ¦r«¬ºA§e²{¡A¦p¢¶¢¯¢°¡B¢¶¢¯¢±¡D¡D¡D¡D¡A¢·¢¯¢°¡B¢·¢¯¢±¡D¡D¡D¡D¡A¢¸¢¯¢°¡B¢¸¢¯¢±¡D¡D¡D¡D
¦p¤µ­n¦b¢ÐÄæ¥t¥~³]¥ß¥H°ê¦r§e²{ªº¯Z¯Å¸ê®Æ¡A¦p¢¶¢¯¢°§ï¬°¤C¦~¤@¯Z¡A¢·¢²¢·§ï¬°¤K¦~¤T¤Q¤K¯Z¡D¡D¡D¡D¥H¦¹Ãþ±À
¦]¬°¥þ®Õ¯Z¯Å¼Æ¦³¤@¦Ê¦h¯Z¡A¯à§_½Ð±Ð«e½ú­Ì¥Î¤°»ò§Ö³t¤½¦¡Âà´«¸ê®Æ¡AÁÂÁ½ç±Ð¡I

=TEXT(INT(A1/100),"[DBNum1]")&"¦~"&TEXT(MOD(A1,100),"[DBNum1]")&"¯Z"
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¦^´_ 2# gong


¤Ó·PÁ±z¤F¡ã©ú¤Ñ¤@¦­¥i¥H¨ì¾Ç®Õ¥æ®tÅo¡I
¦b¤U¾ÇÃÀ¤£ºë¡A¥i§_¦A½Ð°Ý¤@¤U¡ã¨º¨Ç¯S®í¥N½X¡]¥]¬A¤é´Áµ¥¡^¥i¥H¨ì­þ¸Ì¬d¸ß©O¡HÁÂÁ¡I

TOP

¦^´_ 2# gong

­è­è¦b¥´¤@Äæ¸ê®Æ·Q±NB1ªº¢°¢¯¢°Âà´«¦¨°ê¦r«¬ºA¤@¦Ê¹s¤@¡A¤½¦¡¬°=TEXT(B1,"[DBNum1]")¡Aµ²ªG«o¥X²{¤@¦Ê¢Ý¤@
½Ð±Ð«e½ú¸Ó¦p¦ó­×¥¿¡AÁÂÁ¡I

TOP

¦^´_ 2# gong


¹ï¤£°_¡I­è­è¿é¤J¢¶¢°¢²®É¤~»®µMµo²{¥¦·|¥X²{¤C¦~¤@¤Q¤T¯Zªº°ê¦r«¬ºA¦Ó«D¤C¦~¤Q¤T¯Z¡A¥u¦n¦A½Ð±Ð«e½ú¸Ó·í¦p¦ó¡HÁÂÁ¡I

TOP

½s¿è¨ú¥N³Ì§Ö
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

Àx¦s®æ®æ¦¡>¯S®í>¥ý¿ïÃþ«¬>¦Û­q
´N¥i¥H¬Ý¨£¤F
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

a.jpg
2011-4-25 22:19

TOP

=SUBSTITUTE(TEXT(INT(A1/100),"[DBNum1]")&"¦~"&NUMBERSTRING(MOD($A1,100),1)&"¯Z","¤@¤Q","¤Q")
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

chin15 µoªí©ó 2011-4-25 22:19



    ¥Î¤é´ÁÅã¥Ü¤è¦¡½T¹ê¤£¿ù
¸É¥R¤@ÂI¤é´ÁÅã¥Ü³Ì¤j31,¦pªG¯Z¯Å§O¶W¹L28¥i¯à­n¤p¤ß¨Ï¥Î
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

        ÀR«ä¦Û¦b : ¤f»¡¦n¸Ü¡B¤ß·Q¦n·N¡B¨­¦æ¦n¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD