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

[µo°Ý] ½Ð±ÐÀx¦s®æ ùتº¼Æ¦r«e­±¬°¼Æ¦r0¡A·|®ø¥¢~¦p¦ó¥Îvba¸É¤W~~~¡C

[µo°Ý] ½Ð±ÐÀx¦s®æ ùتº¼Æ¦r«e­±¬°¼Æ¦r0¡A·|®ø¥¢~¦p¦ó¥Îvba¸É¤W~~~¡C

½Ð±ÐÀx¦s®æ ùتº¼Æ¦r«e­±¬°¼Æ¦r0¡A·|®ø¥¢~¦p¦ó¥ÎVBA¸É¤W~~~¡C
sub test()
Cells(2, 3) = "04758266"
end sub

¥¼©R¦W.jpg
2015-4-18 02:39


½Ð±Ð¦p¦ó¥Îvba¹F¨ì  ="         "  ªº¥\¯à
ÁÙ¬O¦³¨ä¥L¤èªk©O¡H

¦^´_ 1# ji12345678
  1. Columns("c").NumberFormatLocal = "@"
½Æ»s¥N½X
±NÀx¦s®æ«ü©w¬°"¤å¦r®æ¦¡"§Y¥i
PKKO

TOP

¦b0ªº«e­±¦h¥´¤@­Ó²Å¸¹¡q¤W¤Þ¸¹¡r      '04758266
Cells(2, 3) = "'04758266"

TOP

        ÀR«ä¦Û¦b : ¬°¤H³B¥@­n¤p¤ß²Ó¤ß¡A¦ý¤£­n¡u¤p¤ß²´¡v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD