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

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

¦^´_  gong

­è­è¦b¥´¤@Äæ¸ê®Æ·Q±NB1ªº¢°¢¯¢°Âà´«¦¨°ê¦r«¬ºA¤@¦Ê¹s¤@¡A¤½¦¡¬°=TEXT(B1,"[DBNum1]")¡Aµ²ªG ...
onegirl0204 µoªí©ó 2011-4-25 20:36



    =SUBSTITUTE(TEXT(A1,"[DBNum1]"),"¡³","¹s")
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

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

¦^´_ 9# gong


·PÁ½ç±Ð¡I³o¦¸ªº¤½¦¡¤w´ú¸Õ¦¨¥\Åo¡I¦U¦~¯Å¯Z¯Å¼Æ¤Ö«h¢²¢¶¯Z¡A¦h«h¯}¢³¢¯¯Z¡A©Ò¥H¤~»Ý­n¤½¦¡Âà´«§r¡I
¦³Ãö¼Æ¦r¢°¢¯¢°Âà´«¦¨¤@¦Ê¹s¤@«¬ºAªº¤½¦¡¡A¤´½Ð«e½ú¦A¦¸½ç±Ð¡AÁÂÁ¡I
©êºp¡ã§Ú¥´¦r¤ÓºC¤F¡A«e½ú¤w¦b§Úµo¥X°ÝÃD¤§«e¦^ÂФF¡A­è­èµo§¹°ÝÃD«á¤~²rµMÁ@¨£¡A¦¹¤½¦¡¤]¤w¸g´ú¸Õ¦¨¥\¡A²{¦b´Nµ¥µÛ©ú¤Ñ¨ì¾Ç®Õ­×§ï¸ê®Æ®wÅo¡I¦A¦¸·PÁ±zªº­@¤ß«ü¾É¡I

TOP

´£¨Ñ¤@­Ó¨ç¼Æ¨Ñ¤j¤j­Ì°Ñ¦Ò
A1=123456789
NUMBERSTRING(A1,1)  ¼Æ¦rÂà°ê¦r   ¤@»õ¤G¤d¤T¦Ê¥|¤Q¤­¸U¤»¤d¤C¦Ê¤K¤Q¤E
NUMBERSTRING(A1,2)  ¼Æ¦rÂà¤j¼g°ê¦r  ³ü»õ¶L¥a°Ñ¨Õ¸v¬B¥î¸U³°¥a¬m¨Õ®Ã¬B¨h
NUMBERSTRING(A1,3)  ¼Æ¦rÂà¤p¼g°ê¦r  ¤@¤G¤T¥|¤­¤»¤C¤K¤E

TOP

¦^´_ 13# jimmuLu


    §Úªº¹q¸£¥ÎNUMBERSTRING(A1,2)·|¥X²{#N/A, ¤£ª¾¬O§_»POFFICEª©¥»¦³Ãö?
¦ý¥Î¦Û­q¼Æ­È®æ¦¡¦³Ãþ¦ü®ÄªG:
[DBNum1][$-404]G/³q¥Î®æ¦¡¡G±Ä¨ú¤¤¤å¦r(¤@¡B¤G¡B¤T¡B¥|¡B¤­¡B¤»¡B¤C¡B¤K¡B¤E¡B¤Q¡B¦Ê¡B¤d¡B¸U)
[DBNum2][$-404]G/³q¥Î®æ¦¡¡G±Ä¨ú¤j¼gªº¤¤¤å¦r(³ü¡B¶L¡B°Ñ¡B¸v¡B¥î¡B³°¡B¬m¡B®Ã¡B¨h¡B¬B¡B¨Õ¡B¥a¡B¸U)
[DBNum3][$-404]G/³q¥Î®æ¦¡¡G±Ä¨ú¥þ§Îªºªü©Ô§B¼Æ¦r(¢°¡B¢±¡B¢²¡B¢³¡B¢´¡B¢µ¡B¢¶¡B¢·¡B¢¸¡B¤Q¡B¦Ê¡B¤d)

TOP

        ÀR«ä¦Û¦b : ¯àµ½¥Î®É¶¡ªº¤H¡A¥²¯à´x´¤¦Û¤v§V¤Oªº¤è¦V¡C
ªð¦^¦Cªí ¤W¤@¥DÃD