¦p¦ó§â¥þ§Î"¥y¸¹¡D"§ï¬°¥b§Î"¥y¸¹."?
- ©«¤l
- 214
- ¥DÃD
- 74
- ºëµØ
- 0
- ¿n¤À
- 296
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- hk
- µù¥U®É¶¡
- 2013-6-17
- ³Ì«áµn¿ý
- 2018-11-3
|
¦p¦ó§â¥þ§Î"¥y¸¹¡D"§ï¬°¥b§Î"¥y¸¹."?
¦p¦ó§â¥þ§Î"¥y¸¹¡D"§ï¬°¥b§Î"¥y¸¹."?
x=strconv("abcd¡Dabcd",vbnarrow)§ï¤£¤F,¤£ª¾¤°»ò°ÝÃD,ÁÂÁ¦U¦ìÀ°¦£ |
|
lmh
|
|
|
|
|
- ©«¤l
- 214
- ¥DÃD
- 74
- ºëµØ
- 0
- ¿n¤À
- 296
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- hk
- µù¥U®É¶¡
- 2013-6-17
- ³Ì«áµn¿ý
- 2018-11-3
|
¦^´_ 2# infoverdad
ÁÂÁÂ2#
§Ú¨S¦³ªí¹F²M·¡,§Ú¦³90¸U±ø¦r¦ê([A1:A900000]),¦³¨Ç¦r¦ê¬O¤@¼Ëªº,¦ý¦]¬°¼ÐÂI²Å¸¹¦³ªº¥Î¥þ§Î,¦³ªº¥Î¥b§Î,©Ò¥H¥²¶·²Î¤@¥Î¥b§Î.
[a1]=strconv([a1],vbnarrow),[a1]¨½¥þ§Î¼ÐÂI²Å¸¹³£§ï¬°¥b§Î¤F,°ß¿W¥þ§Î¥y¸¹,¤£·|³Q§ï¦¨¥b§Î¥y¸¹,¤£ª¾¹D¤°»òì¦],´M¨D¸Ñ¨M¤èªk,ÁÂÁ |
|
lmh
|
|
|
|
|
- ©«¤l
- 214
- ¥DÃD
- 74
- ºëµØ
- 0
- ¿n¤À
- 296
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- hk
- µù¥U®É¶¡
- 2013-6-17
- ³Ì«áµn¿ý
- 2018-11-3
|
¦^´_ 4# faye59
(1)º¥ý¹Dºp,§Úªº©RÃD¬O¿ùªº: x=strconv(y,vbnarrow)>>>y¨½©Ò¦³¥þ§Î¼ÐÂI²Å¸¹³£§ï¦¨¥b§Î¼ÐÂI²Å¸¹,µ²ªGx¬O¥¿½Tªºµª®×.
¤§©Ò¥H§Ú·|´£¥X¿ù»~©RÃD¬O¦]¬°§Ú¦¬¶°¨ìªº"¦r¦ê"¨½¥]§tªº¤£¬O"¥þ§Î¼ÐÂI¡D"¡A¤£ª¾¹D¬O¤°»ò²Å¸¹»ª¦ü¥þ§Î¥y¸¹,©Ò¥Hstrconv¨ç¼Æ¤£¯à§â¥¦Âର¥b§Î¥y¸¹.
(2) §Ú²{¦b¨Ï¥Î³oÓ¤èªk>>>> r1.Replace "¡D", ".", xlPart>>>>r1=[a1:a100000],10¸UÓ¦r¦ê¨½¤£©ú²Å¸¹¡D¥þ³¡§ï¬°.¤F |
|
lmh
|
|
|
|
|