excel¤¤³]¸m³æ¾Ú¶½Xªº°ÝÃD
- ©«¤l
- 3
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 4
- ÂI¦W
- 0
- §@·~¨t²Î
- windows
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¤¤°ê¤j³°¼sªFªF²ð
- µù¥U®É¶¡
- 2010-5-19
- ³Ì«áµn¿ý
- 2011-1-15
|
excel¤¤³]¸m³æ¾Ú¶½Xªº°ÝÃD
½Ð±Ð¦U¦ì¤j«L
§Ú·Q¦bexcel¤¤³]¸m¤@Ó²©ö¡§°e³f³æ¡¨¶±¡A»Ýn³]¸m¤@Ó°e³f³æ¦Û°Ê½s½X¸¹¡A¥Î¡§¦~¤ë¤é+¶}³æ¥÷¼Æõìp¡¨ªº¤è¦¡¡A¦p100519001¡B100519002¡B¡C¡C¡C¡A½Ð±Ð¡A¦p¦ó¥Î¤½¦¡³]¸m¡A¤~¯à¨Ï±o³æ¸¹¦b·í¤Ñ¤¤¦Û°Ê³sÄò½s¸¹¡H§Ú·Q³o¼Ë¡A¦b°e³f³æ³æ¾Ú®ÇÃä³]¸m¤@Ó¤â°Ê¡§«O¦s¡¨ªº«öÁä¡A¨C«O¦s¤@¦¸¡A³æ¾Ú¶±¦Û°Ê¥t¦s¡A¨C«O¦s¤@¦¸¡A³æ¾Ú½s¸¹¦Û°Ê¨ê·s¤@Ó¡Aª½¨ì¤é´Á´«¤U¤@¤Ñ¶}©l¡A³æ¾Ú½s¸¹¦A±qÀY¶}©l¡C§Ú¤£ª¾¦p¦ó³]¸m¡A½Ð±Ð¦U¦ìÀ°À°¦£§a¡A¦b¦¹·PÁ¤F¡C |
|
¤ÑªÅ¥ô³¾¸¡A®üÁï¥ô³½¹C¡A¥@¶¡¥ô§Ú¦æ
|
|
|
|
|
- ©«¤l
- 1180
- ¥DÃD
- 204
- ºëµØ
- 0
- ¿n¤À
- 1051
- ÂI¦W
- 0
- §@·~¨t²Î
- Mac.OS10.6
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-3
- ³Ì«áµn¿ý
- 2012-9-19
|
½Ð±Ð¦U¦ì¤j«L
§Ú·Q¦bexcel¤¤³]¸m¤@Ó²©ö¡§°e³f³æ¡¨¶±¡A»Ýn³]¸m¤@Ó°e³f³æ¦Û°Ê½s½X¸¹¡A¥Î¡§¦~¤ë¤é+¶}³æ ...
¥ô§Ú¦æ µoªí©ó 2010-5-19 09:37
¼Ó¥Dªº°ÝÃD
¥HHSª©¥Dªº¸Ñµª½d¨Ò¤ñ¸û¦X¥G±z·Qnªº¼Ò¦¡.¤£¯à¤U¸ü½Ð°Ñ·Ó8#ªº¹Ï¥Ü¥h§¹¦¨
Y¥H©w¸q¦WºÙ¥h°õ¦æ..³æ¾Ú¶±¤£·|¦Û°Ê¥t¦s¨ì¨ä¥L¶±
©Ó¦pGONGª©¥D©Ò¨¥..¦¹ÃD¤£¾A¥Î©ó¤@¯ë°Ï,¥i¯à·|¦³«½Æ°Ñ·Óªº°ÝÃD |
|
|
|
|
|
|
- ©«¤l
- 812
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 862
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¤¤
- µù¥U®É¶¡
- 2010-5-13
- ³Ì«áµn¿ý
- 2019-10-10
|
©w¸q¦WºÙ
YYMMDD=TEXT(TODAY(),"YYMMDD")
¤½¦¡¬°
A2=IF(LEFT(A2,6)=YYMMDD,A2+1,--(YYMMDD&"001")) |
|
|
|
|
|
|
- ©«¤l
- 812
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 862
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¤¤
- µù¥U®É¶¡
- 2010-5-13
- ³Ì«áµn¿ý
- 2019-10-10
|
©w¸q¦WºÙ:
YY=TEXT(RIGHT(YEAR(TODAY()),2),"00")
MM=TEXT(MONTH(TODAY()),"00")
DD=TEXT(DAY(TODAY()),"00")
2003¤½¦¡¬°
A2=IF(ISERROR((yy&mm&dd&TEXT(RIGHT(LOOKUP(2,1/(LEFT($A$1:A1,6)=yy&mm&dd),$A$1:A1),3),"000"))+1),--(yy&mm&dd&"001"),(yy&mm&dd&TEXT(RIGHT(LOOKUP(2,1/(LEFT($A$1:A1,6)=yy&mm&dd),$A$1:A1),3),"000"))+1) |
|
|
|
|
|
|
- ©«¤l
- 812
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 862
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¤¤
- µù¥U®É¶¡
- 2010-5-13
- ³Ì«áµn¿ý
- 2019-10-10
|
©êºp,¥Î¤F2007¤½¦¡,2003½Ð¬Ýªþ¥ó
©w¸q¦WºÙ¤½¦¡¸û²¼ä. |
-
-
Book1.zip
(4.06 KB)
|
|
|
|
|
|
- ©«¤l
- 3
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 4
- ÂI¦W
- 0
- §@·~¨t²Î
- windows
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¤¤°ê¤j³°¼sªFªF²ð
- µù¥U®É¶¡
- 2010-5-19
- ³Ì«áµn¿ý
- 2011-1-15
|
gongª©¥D¡A§Ú¤£ª¾¹D¦p¦ó²¾°Ê°ÝÃD¨ìµ{¦¡°Ï¡A½ÐÀ°À°¦£¦n¶Ü¡H«D±`·PÁ¡I
©ÎªÌ¨ìµ{¦¡°Ï«·s°µ¤@Ó¥DÃDµo°Ý¡H |
|
¤ÑªÅ¥ô³¾¸¡A®üÁï¥ô³½¹C¡A¥@¶¡¥ô§Ú¦æ
|
|
|
|
|
- ©«¤l
- 3
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 4
- ÂI¦W
- 0
- §@·~¨t²Î
- windows
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¤¤°ê¤j³°¼sªFªF²ð
- µù¥U®É¶¡
- 2010-5-19
- ³Ì«áµn¿ý
- 2011-1-15
|
·PÁ¨â¦ì¤¯¥Sªº¼ö¤ß
Hsieh °µªºªþ¥ó¡A§Ú¨S¦³Åv¤U¸ü©Î¬d¬Ý¡I
ANGELA °µªº¤½¦¡¡A§Ú½Æ»sÖ߶K¨ìexcelªí¤¤¡A«o±o¤£¥X¤°»òµ²ªG¡I¤£ª¾¦p¦ó¾Þ§@¤~¦n¡AÁٽнç±Ð¡C
Á`¤§¡A«D±`·PÁ¨â¦ìªº´©¤â¤§¼w°Õ |
|
¤ÑªÅ¥ô³¾¸¡A®üÁï¥ô³½¹C¡A¥@¶¡¥ô§Ú¦æ
|
|
|
|
|