µù¥U
µn¿ý
º¶
½×¾Âª©³W
¸T¤î¦Cªí
»¡©ú
¦a¹Ï
¼Æ¦ì®Ñ»
¨p¤H®ø®§ (0)
¤½¦@®ø®§ (0)
½×¾Â¥ô°È (0)
¨t²Î®ø®§ (0)
¦n¤Í®ø®§ (0)
©«¤l®ø®§ (0)
³Â»¶®a±Ú°Q½×ª©ª©
»
Excel£¸¯ë°Ï
» excel ¤½¦¡°ÝÃD #VALUE
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
µo©«
[µo°Ý]
excel ¤½¦¡°ÝÃD #VALUE
symis
µoµu®ø®§
¥[¬°¦n¤Í
symis
·í«eÂ÷½u
UID
60
©«¤l
42
¥DÃD
13
ºëµØ
0
¿n¤À
61
ª÷¿ú
61
ÂI¦W
0
§@·~¨t²Î
xpp-sp2
³nÅ骩¥»
2003sp2
¾\ŪÅv
20
¦b½u®É¶¡
17 ¤p®É
µù¥U®É¶¡
2010-5-4
³Ì«áµn¿ý
2017-1-24
¤¤¾Ç¥Í
©«¤l
42
¥DÃD
13
ºëµØ
0
¿n¤À
61
ÂI¦W
0
§@·~¨t²Î
xpp-sp2
³nÅ骩¥»
2003sp2
¾\ŪÅv
20
µù¥U®É¶¡
2010-5-4
³Ì«áµn¿ý
2017-1-24
1
#
¸õÂà¨ì
»
˧Ǭݩ«
¥´¦L
¦rÅé¤j¤p:
t
T
µoªí©ó 2013-12-1 13:39
|
Åã¥Ü¥þ³¡©«¤l
[µo°Ý]
excel ¤½¦¡°ÝÃD #VALUE
¦p¤U¸ü³sµ²
http://www.2shared.com/file/ajEuxUaL/999.html
§ï¤FÀx¦s®æ®æ¦¡,¤]±NK,LÄ檺ÈCOPY¨ì§O³B,¦ACOPY¦^,³£¨S¥Î!
§Ú(´ú¸Õ)§âJ,K,L¤TÄæ«KEY IN ¼Æ¦r,§YOK
°Ý1: JÄ椽¦¡¦³¤°»ò°ÝÃD¶Ü?
°Ý2: ¬°¦ó§Ú§âJÄæ(´ú¸Õ)ª½±µKEY IN ¼Æ¦r,¤´¤£¦æ? K,LÄ榳¦ó°ÝÃD?
°Ý3: ¬°¦ó¥u¦³L26ª½±µ«KEY IN¼Æ¦r§YOK?
ÁÂÁ¦^µª!
¼Ó¥D¼ö©«
EXCEL VBA¡D¦p¦ó¦Û°Ê¿é¤J¸ê®Æ(¥Htab¸õ¤U¤@®æ
Excel2003µe±×½u
Excel2003 ¼Æ¦r®æ¦¡¦p¦óÅܧ¹¾ã¤å¦r?
©Þ¥XÀH¨ºÐ®É,¹q¸£¥ß¨è±Ò°ÊÃö¾÷µ{§Ç
excel vba ÄݩʬOªÅªº
word2013ªí®æ¦p¦ó·í¶§À?
word ´¡¹Ï¤ù½s¸¹
MS SQL full join°ÝÃD
¦p¦ó¥Hvba¦C¥X¥Ø«eªº¤@¨Ç³]©w,Âରcode?
¦p¦ó¨q¥X©Ò¦³¥i¨£¤§sheet name?
¦¬ÂÃ
¤À¨É
Symis
symis
µoµu®ø®§
¥[¬°¦n¤Í
symis
·í«eÂ÷½u
UID
60
©«¤l
42
¥DÃD
13
ºëµØ
0
¿n¤À
61
ª÷¿ú
61
ÂI¦W
0
§@·~¨t²Î
xpp-sp2
³nÅ骩¥»
2003sp2
¾\ŪÅv
20
¦b½u®É¶¡
17 ¤p®É
µù¥U®É¶¡
2010-5-4
³Ì«áµn¿ý
2017-1-24
¤¤¾Ç¥Í
©«¤l
42
¥DÃD
13
ºëµØ
0
¿n¤À
61
ÂI¦W
0
§@·~¨t²Î
xpp-sp2
³nÅ骩¥»
2003sp2
¾\ŪÅv
20
µù¥U®É¶¡
2010-5-4
³Ì«áµn¿ý
2017-1-24
2
#
µoªí©ó 2013-12-4 00:35
|
Åã¥Ü¥þ³¡©«¤l
¥i¦æC, ·P®¦!
½Ð°Ý,CODE 63ªº½X,¬O«ç»ò¬Ý¥X¨Óªº?
Symis
TOP
symis
µoµu®ø®§
¥[¬°¦n¤Í
symis
·í«eÂ÷½u
UID
60
©«¤l
42
¥DÃD
13
ºëµØ
0
¿n¤À
61
ª÷¿ú
61
ÂI¦W
0
§@·~¨t²Î
xpp-sp2
³nÅ骩¥»
2003sp2
¾\ŪÅv
20
¦b½u®É¶¡
17 ¤p®É
µù¥U®É¶¡
2010-5-4
³Ì«áµn¿ý
2017-1-24
¤¤¾Ç¥Í
©«¤l
42
¥DÃD
13
ºëµØ
0
¿n¤À
61
ÂI¦W
0
§@·~¨t²Î
xpp-sp2
³nÅ骩¥»
2003sp2
¾\ŪÅv
20
µù¥U®É¶¡
2010-5-4
³Ì«áµn¿ý
2017-1-24
3
#
µoªí©ó 2013-12-5 13:42
|
Åã¥Ü¥þ³¡©«¤l
¤S¾Ç¨ì¤@©Û
·P®¦!
¦³¤H±Ð§Ú¥t¤@©Û(VBA),µ¹±z°Ñ¦Ò:
Sub abc()
Dim s As Worksheet
Set s = ActiveSheet
Dim i As Integer
Dim k As String
Set w = ActiveWorkbook
For i = 3 To 27
'¥H¤U³]©w¼Æ¦r®æ¦¡¤p¼Æ¨â¦ì
s.Range("K" & i).NumberFormatLocal = "0.00_ "
s.Range("L" & i).NumberFormatLocal = "0.00_ "
s.Range("M" & i).NumberFormatLocal = "0.00_ "
'«·sµ¹È
k = s.Range("K" & i).Value
s.Range("K" & i).Value = Val(k)
k = s.Range("L" & i).Value
s.Range("L" & i).Value = Val(k)
Next i
MsgBox "³B²zOK"
End Sub
Symis
TOP
ÀR«ä¦Û¦b :
§Ñ¥\¤£§Ñ¹L¡A§Ñ«è¤£§Ñ®¦¡C
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
EXCEL±MÄÝ°Q½×°Ï
Excel£¸¯ë°Ï
Excelµ{¦¡°Ï
¶i¶¥À³¥Î±M°Ï
OFFICE ¨t¦C
Word
PowerPoint
Access
Office¤£¤À°Ï
µ{¦¡»y¨¥
VB »P VB.Net
C »P C#
Java »P J#
µ{¦¡³]p¤£¤À°Ï
¸ê®Æ®w
ORACLE
My SQL
MS SQL
ºô¶³]p
ASP »P ASP.NET
PHP
PHP+MySQL ¤Jªù¹ê§@
JavaScript
FLASH / ActionScript
HTM/ HTML/ CSS
ºô¶³]p¤£¤À°Ï
¹q¸£»P§@·~¨t²Î
¹q¸£¦UºØµwÅé°Q½×
¤@¯ë¹q¸£³nÅé°Q½×
½×¾Â¨Æ°È
ºÞ²z¤½§i
§ë¶D¤Ï¬M
·s¤â´ú¸Õ
·R ¡E ¥Í¬¡
¤½¯q§G§iÄæ
¥Í¬¡»P·P°Ê
[¦¬Âæ¹¥DÃD]
[Ãöª`¦¹¥DÃDªº·s¦^´_]
[³q¹L QQ¡BMSN ¤À¨Éµ¹ªB¤Í]
¥Ó½Ð¤Í±¡Ãì±µ
Facebook¯»µ·