![]() |
||
|
Advance Member
![]() ![]() ¥[¤J¤é´Á: Mar 2005
¤å³¹: 377
|
excel°ÝÃD.......
½Ð°Ý§Ú¦bexcel®æ¤l¸Ì¥´¥X¥Í¦~¤ë¤é¡A¤ñ¦p¥Á°ê98/03/09¡A¬°¦ó¥¦³£¬O§â§A§ï¦¨1998/03/09......§Ú¦A§ï¦^¨Ó«öenter¡A¥¦ÁÙ¬O 1998/03/09¡H.......½Ð°Ýn¦p¦ó³]©w¤~¯à²Å¦X§Úªº»Ý¨D©O¡HÁÂÁÂ
|
|||||||
|
|
|
Major Member
![]() ¥[¤J¤é´Á: Nov 2003
¤å³¹: 130
|
¦]¬°³nÅé¹w³]¬O¦è¤¸
Àx¦s®æ®æ¦¡¡÷¤é´Á¡÷¤¤µØ¥Á°ê |
||
|
|
|
Advance Member
![]() ![]() ¥[¤J¤é´Á: Dec 2002
¤å³¹: 441
|
¨âÓ°ÝÃD
1.excel¹w³] 30¦~¥H«á¦Û°Ê¥[19¡A29¦~«e¥[20 ex 30/01/01 -> 1930/01/01¡A29/01/01->2029/01/01 ¦n¹³³]©w¥i¥H§ï¡A±Í¤H¹ï¦¹¨S¿³½ì¡A¤]¨S¬ã¨s ¦pªGn¥H°ê¾ä¤é´Á¿é¤J¡G½Ð¥[Ór ¨Ò r98/01/01>enter ¨t²Î·|¦Û°Ê§P©w¬°°ê¾ä¤é´Á¡A®æ¦¡·|¦Ûq¦¨°ê¾ä¤é´Á¡AÅã¥Ü 98/1/1¡A¹ê»Ú¬Ýexcel®æ¦ì¡A·|¬Ý¨ì 2009/1/1 ¨S¥[¨ºÓ r¡A¨t²Î·|¦Û°ÊÀ°§A½Õ¾ã¦è¾ä 2.¦P¼Ó¤W»¡ Àx®æ¦¡->¤é´Á>¤¤µØ¥Á°ê¤é´Á®æ¦¡¡A¦³¦hÓ¡A§A·Qnªº¬O 90/3/14 ¦pªGn§¹¥þ¹ï»ô¡A¥i¦Ûq¬° e/mm/dd¡Am©Md³£¨âÓ 90/1/1·|Åã¥Ü¦¨ 90/01/01 ³oÓ¹ïexcel¤£¼ôªº¤H¦³ÂIÃø¡A½Ð¦Û¤v§@§@¥\½Ò¦Aµo°Ý..... |
|
|
|
Golden Member
![]() ![]() ![]() ![]() ¥[¤J¤é´Á: Mar 2000 ±zªº¦í§}: ¬y®ö¤¤.....
¤å³¹: 3,572
|
ÉÃD°Ý¤@¤U
¤§«e EXCEL ¦³Ó¥\¯à«öÁä¥i¥H¦Û°Ê¤Á´« ¥þ¤j¼g¤p¼g^¤åªº ~ ¤µ¤ÑºN¤F¾ãÓ¤U¤È§ä¤£¨ì@@ °O±o¤§«e´N¥Î¹Lªº ·Q½Ð°Ý¤j®a¦³¨S¦³¥Î°£¤F¿é¤J¨ç¼Æ¤§¥~ªº¿ìªk?? ÁÂÁ ![]() |
|
|
|
Advance Member
![]() ![]() ¥[¤J¤é´Á: Dec 2002
¤å³¹: 441
|
¤Þ¥Î:
word¡ASHIFT-F3 EXCEL¡A©çÁ¡A¨S¦L¶H¡A¦P¨D°ª¤H«üÂI¡C |
|
|
|
|
Major Member
![]() ¥[¤J¤é´Á: Nov 2003
¤å³¹: 130
|
excel¥þ¤j¼g¥i¥H¥Îupper¡A¤p¼glower
¨Ò¡Ga1=pcdvd ¨º»òb1=upper(a1) µ²ªGb1=PCDVD ¤£µM´N¬O°t¦XVBA¨Ó°µ¾ã¶§Ö³t¤Á´« n¥\¯àÁä¤Á´«¡A·sª©ªºÓ¤H¨S¥Î¹L¡A¦³µL¤º«Ø¤£²M·¡ ²Ä¤T¤è¥~±¾kutoolsùرªºtext tools¥i¥H°µ¨ì¤@Áä¤Á´« ¤£·Q¥Î¨ç¼Æ¡BVBA¡B¥~±¾¡A³Ì²³æ´N¬O¶K¨ìword³B²z§¹ ¦A¶K¦^excel |
|
|