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

[µo°Ý] Àx¦s®æµLªkÅã¥Ü°Ñ·Ó¤º®e¡A¦ÓÅã¥Ü°Ñ·Ó¤½¦¡

[µo°Ý] Àx¦s®æµLªkÅã¥Ü°Ñ·Ó¤º®e¡A¦ÓÅã¥Ü°Ñ·Ó¤½¦¡

¥»©«³Ì«á¥Ñ engineer ©ó 2011-10-29 22:45 ½s¿è

¤@.½Ð±Ð°Q½×°Ï¦U¦ì¥ý¶i¡AÀx¦s®æ(¸Ôªþ¥ó)A4µLªkÅã¥Ü¸Ó°Ñ·ÓÀx¦s®æ¤º®e(§õxx)¡A¦ÓÅã¥Ü¥X¤½¦¡(=¤u¦a!A20)¡AÀ³¦p¦ó±Æ°£¦¹°ÝÃD.
¤G.¸ÓÀÉ®×­ì¥HEXCEL 2010«Ø¥ß¡A«á¥HEXCEL 2003½s¿è­×§ï¡A¬O§_¥i¯à¬Oª©¥»®t²§¾É­P.
¤T.½Ð´f¤©«ü±Ð.ÁÂÁÂ

ªí_1.rar (11.16 KB)

50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

¦^´_ 1# engineer


    ¥Î¸ê®Æ­åªR±N®æ¦¡§ï¬°¤@¯ë
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

RE: Àx¦s®æµLªkÅã¥Ü°Ñ·Ó¤º®e¡A¦ÓÅã¥Ü°Ñ·Ó¤½¦¡

¦^´_  engineer


    ¥Î¸ê®Æ­åªR±N®æ¦¡§ï¬°¤@¯ë
Hsieh µoªí©ó 2011-10-30 08:37


¤@.¥H¸ê®Æ­åªR§ó§ï¡A©óµo°Ý«e¤v¸Õ¹L¡A¬O¥i逹¨ì©Ò¶·»Ý¨D¡A°ß¦A¦¸²§°Ê°Ñ·Ó®ÉÁÙ¬Oµo¥Í¬Û¦P±¡§Î.
¤G.¬G¤W°Q½×ª©´£°Ý°Q½×¡A·PÁª©¥D¼·¤®¦^ÂÐ.ÁÂÁ engineer±Ò
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

  1. Private Sub Worksheet_Activate()
  2. For Each c In [a:a].SpecialCells(2)
  3. c.NumberFormatLocal = "G/³q¥Î®æ¦¡"
  4. c.Value = c.Formula
  5. Next
  6. End Sub
½Æ»s¥N½X
©ñ¦b¤W¯Z®É¼Æ¤u§@ªí¼Ò²Õ¤¤

TOP

        ÀR«ä¦Û¦b : «Î¼e¤£¦p¤ß¼e¡C
ªð¦^¦Cªí ¤W¤@¥DÃD