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

[µo°Ý] ®y¦ì¼ÐÅÒ»s§@

[µo°Ý] ®y¦ì¼ÐÅÒ»s§@

®y¦ì¸¹½X.zip.zip (7 KB)



¤j¤j­Ì¦n:
¤p§Ì·Q°µ¤@¥÷®y¦ì¼ÐÅÒ¡A¦b¤J³õ°Ïµo©ñªº
¦]¬°·|³õ®y¦ì¨C±Æ½s½X¦p¹q¼v°|   ¨Ò¦p:    ²Ä¤@±Æ   9.7.5.3.1.2.4.6.8.10
©Ò¥H¥²¶·¿n¼Æ°¸¼Æ¤À¶}
½Ð°Ý¤j¤j¦³¿ìªk¦p¤W¹Ï¤@¼Ë³]©w¶Ü
¤£µM§Ú³£­n¤@®æ¤@®æKEY IN
¦³2000¦h­Ó¦ì¸m¤]·|KEY¨ì¤â³n~"~
¤£·|EXCALLªº²Â³J

¥»©«³Ì«á¥Ñ p212 ©ó 2014-4-24 08:55 ½s¿è

¦^´_ 1# prince0413
ªü©Ô§B¼Æ¦rÂà´«¦¨¤¤¤å®æ¦¡¼Æ¦r(1¡÷¤@¡B2¡÷¤G¡B...)¡A¨Ï¥ÎTEXT(value,format_text)¡A¨äformat_text½Ð³]¬°"[DBNum1]"¡C
´«¦C¨Ï¥Î¡GCHAR(10)
¸Õ¸Õ¬Ý¡I

®y¦ì¸¹½X_2.zip (8.3 KB)

TOP

¦^´_ 2# p212


¤j¤j±z¦n
§Ú¦³¤U¸ü±zªºÀÉ®×  ·Ó±z»¡ªº§â¼Æ­È®æ¦¡§ï±¼¡A½Ð°Ý³o¼Ë¹ï¶Ü?(¦p¤W¹Ï)
¦ý±q²Ä¤Q±Æ¤§«áÅã¥Üªº³£©Ç©Çªº¡A²Ä¤Q±ÆÅܲĤ@¤Q±Æ¡B²Ä¤Q¤@±ÆÅܲĤ@¤Q¤@±Æ .....(¦p¤U¹Ï)

   
½Ð°Ý¬°¤°»ò·|³o¼Ë©O¡A½Ð¤j¤j¸Ñµª~~~
³Â·Ð¤F
¤£·|EXCALLªº²Â³J

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2014-4-25 00:19 ½s¿è

¦^´_ 3# prince0413
1¡B±ý±N¡u¤@¤Q¡v§ï¦¨¡u¤@¡³¡v¡B¡u¤@¤Q¤@¡v§ï¦¨¡u¤@¤@¡v¡A«h½Ð±N2#ªþ¥ó¤§
Àx¦s®æB2¤½¦¡­×§ï¦¨
="²Ä"&TEXT(B$1,"[DBNum1]0")&"±Æ"&CHAR(10)&ROW(1:1)*2-1&"¸¹"
Àx¦s®æC2¤½¦¡­×§ï¦¨
="²Ä"&TEXT(C$1,"[DBNum1]0")&"±Æ"&CHAR(10)&ROW(1:1)*2&"¸¹"
¦A°é¿ï½d³ò¡]¦p¤Ï¥ÕB1:C7½d³ò¡^¦V¥k½Æ»s¤½¦¡§Y¥i¡I
2¡B2#ªþ¥ó¤§²Ä¤@¦C½Ð«O¯d¬°ªü©Ô§B¼Æ¦r®æ¦¡§Y¥i¡A¤ð»Ý§ï¦¨¤¤¤å®æ¦¡¼Æ¦r¡C
½Ð°Ñ¦Ò¡I

TOP

¥»©«³Ì«á¥Ñ prince0413 ©ó 2014-4-25 14:01 ½s¿è

¦^´_ 4# p212

¤j¤j±z¦n

¸g´ú¸Õ¤½¦¡¥¼·Ó±z»¡ªº­×§ï«e¡A¥u¦³10~19±ÆÅã¥Ü·|¤£¥¿±`(10:¤@¤Q¡B11:¤@¤Q¤@¡B12:¤@¤Q¤G ...)¡A¦ý20±Æ¤§«á³£¥¿±`¤F(20:¤G¤Q¡B21:¤G¤Q¤@¡B22:¤G¤Q¤G...)

¦³¿ìªk§â10~19±ÆÅã¥Ü¦¨  ²Ä¤Q±Æ¡B²Ä¤Q¤@±Æ¡B²Ä¤Q¤G±Æ....³o¼Ë¶Ü?

¦pªG¤£¦æ¡A¬O§_§ï¦¨ªü©Ô§B¼Æ¦r·|¸û¤è«K©O?
¦p:  ²Ä1±Æ  1¸¹  ...²Ä11±Æ  1¸¹ ....     

½Ð¤j¤j«ü±Ð~"~
¤£·|EXCALLªº²Â³J

TOP

¦^´_ 4# p212

¤j¤j±z¦n
¤p§Ì­è­èª¦¤å¡Aµo²{§â"0"§ï¦¨"d"    ´N¥¿±`¤F~

="²Ä"&TEXT(T$1,"[DBNum1]d")&"±Æ"&CHAR(10)&ROW(1:1)*2-1&"¸¹"   

ÁÂÁ±zªºÀ°¦£!!
·P®¦
¤£·|EXCALLªº²Â³J

TOP

        ÀR«ä¦Û¦b : ±o²z­nÄǤH¡A²zª½­n®ð©M¡C
ªð¦^¦Cªí ¤W¤@¥DÃD