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

[µo°Ý] ¸É¹sªº¨â­Ó¼Æ¦r¦p¦ó¦X¨Ö

[µo°Ý] ¸É¹sªº¨â­Ó¼Æ¦r¦p¦ó¦X¨Ö

¥»©«³Ì«á¥Ñ wind6424 ©ó 2013-6-4 14:18 ½s¿è

·Q½Ð°Ý,A1 ¸òB1 ³£¦³¨Ï¥ÎÀx¦s®æ®æ¦¡¦Û­q¸É¹s,
§Ú·Q±NA1¸òB1¦ê°_¨Ó¬°00101 ¶ñ¦bC1,
¨Ï¥ÎC1=A1&B1 ·|Åܦ¨11,­n¦p¦ó¤~¯à¦ê¦¨00101

¼Æ¦r.png
2013-6-4 14:12

¦^´_ 1# wind6424

¥ÎTEXT¨ç¼Æ¡A®æ¦¡´N¸ò§A­ì¥»³]ªº¤@¼Ë§Y¥i
¥H§A³o­Ó¨Ó»¡¡AÀ³¸Ó¬O
  1. =TEXT(A1,"000")&TEXT(B1,"00")
½Æ»s¥N½X

TOP

¥»©«³Ì«á¥Ñ ML089 ©ó 2013-6-4 20:40 ½s¿è

C1 =A1*100+B1
Àx¦s®æ®æ¦¡ - ¦Û©w - 00000

©Ò¥H
A1=1 Åã¥Ü 001
B1=1 Åã¥Ü 01
C1=A1*100+B1=101 ¦Û©w®æ¦¡ 00000 Åã¥Ü¬° 00101
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦pªG­nÅܦ¨¤å¦r®æ¦¡
C1=TEXT(A1*100+B1,"00000")
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

C1 =A1*100+B1
Àx¦s®æ®æ¦¡ - ¦Û©w - 00000

©Ò¥H
A1=1 Åã¥Ü 001
B1=1 Åã¥Ü 01
C1=A1*100+B1=101 ¦Û©w ...
ML089 µoªí©ó 2013-6-4 20:38


ML089 ·PÁ±z´£¨Ñªº¤è¦¡,¦ý¬O¦]¬°B1¤U¤è¦³¤T¦ì¼Æªº®æ¤l,
©Ò¥H±zªº¤è¦¡¦pªG¹J¨ìB1¬°¤T¦ì¼Æªº·|¦³°ÝÃD

TOP

¦^´_  wind6424

¥ÎTEXT¨ç¼Æ¡A®æ¦¡´N¸ò§A­ì¥»³]ªº¤@¼Ë§Y¥i
¥H§A³o­Ó¨Ó»¡¡AÀ³¸Ó¬O
Bodhidharma µoªí©ó 2013-6-4 14:35


§¹¥þ¨S·Q¨ì¹B¥Î¨ç¼Æ¨Ó¸Ñ¨M,
Bodhidharma ¤j,«D±`·PÁ±z,

TOP

¦^´_ 5# wind6424

>ML089 ·PÁ±z´£¨Ñªº¤è¦¡,¦ý¬O¦]¬°B1¤U¤è¦³¤T¦ì¼Æªº®æ¤l,
>©Ò¥H±zªº¤è¦¡¦pªG¹J¨ìB1¬°¤T¦ì¼Æªº·|¦³°ÝÃD
   
³o¬OÃD¥Ø©w¸qªº°ÝÃD¡A
¥Ø«eÃD¥Ø­n±o®æ¦¡¬O 000 & 00¡A B1´N¤£¯à¦³3¦ì¼Æ¡A
¦pªGB1·|¶W¹L2¦ì¼Æ¡A®æ¦¡´N·|¨ü¼vÅT¡A
¨Ò¦p¤U­±¨â¨Òªº²Õ¦XA B¤£¦P¡A²Õ¦X«áÅܦ¨¤@¼Ë¡A¦n¹³§ó©_©Ç¡C
A1=1001, B=101 C1="1001" & "101" = "101101"
A1=1011, B=01   C1="1011" & "01"    = "101101"

¦pªGB1·|¶W¹L2¦ì¼Æ¡A®æ¦¡´NÀ³§ï¬° 000 & 000¤ñ¸û¦X²z
¤½¦¡¥u­n°t¦X­×§ï´N¥i
C1 = A1*1000+B1

¤Ï¥¿³o¨Ç³£¬Oµ¹§A°Ñ¦Ò¡A¦p¦ó¹B¥Î¦U¦Û¥©§®¤£¦P
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 7# ML089

¦P·N³o­ÓÁ¿ªk

§Ú«e­±»¡ªº"¥ÎTEXT¨ç¼Æ¡A®æ¦¡´N¸ò§A­ì¥»³]ªº¤@¼Ë§Y¥i"¡A³oÃä«üªº¬O¡uTEXT¨ç¼Æ¤ºªºformat¡v
¦Ü©ó¥ØªºÄæ(CÄæ)ªº®æ¦¡¡Aªº½TÀ³¸Óµø­ì¥»¸ê®Æªº®æ¦¡¨Ó¨M©w¡A¥H³oÃD¨Ó»¡¡A"00000"¦ü¥G¬O«ê·íªº
·Ó²z¨Ó»¡A¡BBÄæ¬O¼Æ¦r¡A¦]¦¹CÄæ¤]¸Ó¬O¼Æ¦r¡A¦]¦¹¥i¥Î
  1. =--(TEXT(A1,"000")&TEXT(B1,"00"))
½Æ»s¥N½X
³B²z

¦Ü©óBÄæ¥X²{3¦ì(¥H¤W)¼Æªº±¡§Î¡Aªº½T·|¸ò­ì¥»¸ê®Æ³]©wªº¤è¦¡¬Û½Ä¬ð
CÄæ¥Î"00000"®æ¦¡ªº¸Ü¤]¦³¥i¯à¥X°ÝÃD(¤ñ¤è»¡A1=001¡AB1=123¡A«h
C1=--(TEXT(A1,"000")&TEXT(B1,"00"))=1123¡A¨Ì®æ¦¡Åã¥Ü´N·|¬O01123¦Ó¤£¬O001123
¤£¹L·íµMÁÙ¬O­n¬Ý­ìpoªº»Ý¨D¦Ó©w

TOP

¦^´_  wind6424

>ML089 ·PÁ±z´£¨Ñªº¤è¦¡,¦ý¬O¦]¬°B1¤U¤è¦³¤T¦ì¼Æªº®æ¤l,
>©Ò¥H±zªº¤è¦¡¦pªG¹J¨ìB1¬°¤T ...
ML089 µoªí©ó 2013-6-5 11:30


ML089 ¤j¤j,«D±`ªº©êºp,
³o¬O§Úªº°ÝÃD,¨S§â°ÝÃDÂI»¡©ú²M·¡

TOP

        ÀR«ä¦Û¦b : ¨Ã«D¦³¿ú¾{¬O§Ö¼Ö¡A°Ý¤ßµL·\¤ß³Ì¦w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD