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

[µo°Ý] ¯S©w±ø¥ó¦¨¥ß«á¡A´N¦Û°Ê¶ñº¡¶À¦â

[µo°Ý] ¯S©w±ø¥ó¦¨¥ß«á¡A´N¦Û°Ê¶ñº¡¶À¦â

Dear Excel ¥ý¶i,
½Ð±Ð¤@¤U¡A§Ú·Q¦bCÄæ¦ì¤U¨Ï¥Îexcel ±ø¥ó¦¡®æ¦¡³]©w
±NCÄd¤U¡A¥u­n¬O²Ä¤@½X¬°0¶}ÀYªº©Î¬O«e3½X¬°930®É¡A¸ÓÄæ¦ì´N¦Û°Ê¶ñº¡¬°¶À¦â


§Ú·QÅý¥¦Åܦ¨³o¼Ë


TEST.rar (6.78 KB)

¦A«ô°U¤j®aÀ°¦£«ü¾É¤F
Just do it.

¦^´_ 1# jsc0518

½Ð´ú¸Õ¬Ý¬Ý¡AÁÂÁÂ

TEST_0310.zip (23.69 KB)

TOP

¦^´_ 1# jsc0518


  Hello,

    ¥i¨Ï¥Î¦Û°Ê®æ¦¡¥Nªº±ø¥ó¤è¦¡
       1. ¿ï¾Ü½d³ò:: C2:C2000
       2. ¦Û°Ê®æ¦¡¥Nªº±ø¥ó
       3. ·s¼W³W«h
       4. ¨Ï¥Î¤½¦¡¨Ó¨M©w­n®æ¦¡¤Æ¨º¨ÇÀx¦s®æ
       5. ¤½¦¡:: =OR(LEFT($C2,1)="0",LEFT($C2,3)="930")
       6. ®æ¦¡(F).. -> ¶ñº¡:: ¶À¦â
·s¤â¤W¸ô¡A½Ð¦h¥]²[¡C

TOP

¦^´_ 2# samwang
Dear samwang,
¥i¥H¨Ï¥Î¼Ú¡A·PÁ±zªº¦^ÂлP«ü¾É¡I¡I
Just do it.

TOP

¦^´_ 3# ¼B¤j­G
Dear ¼B¤j­G,
Test OK¡AÁÂÁ±zªº±Ð¾É¡I¡I
Just do it.

TOP

        ÀR«ä¦Û¦b : ¤£­nÀH¤ß©Ò±ý¡A­nÀH¤ß±Ð¨|¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD