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

¨D§U!¿é¤J¤å¦rÂà´«¼Æ­È­pºâªº¤èªk

¨D§U!¿é¤J¤å¦rÂà´«¼Æ­È­pºâªº¤èªk

½Ð°Ý¦]¬°»Ý­n¿é¤JªºÀx¦s®æ¤º®e¬°¤G¤À¤§¤@¨ì¦Ê¸U¤À¤§¤@³£¦³¥i¯àªº¤À¼Æ¡A©Ò¥H¥u¦n±NÀx¦s®æ®æ¦¡¤¤ªº¼Æ­È§ï¬°¤å¦r¡A¦ý¬O¤S¥²¶·±N¦¹Àx¦s®æªº¤º®e¥[¥H­pºâ¡A¦b©w¸q¤¤±N¦¹Àx¦s®æªº¤º®e¥ÎevaluateÂà´««á¦A¥´¶}¦¹ÀÉ®×·|¥X²{¦¹¬¡­¶Ã¯¥]§t¤@­Ó©Î¦h­Óexcel 4.0¥¨¶°ªº¹ï¸Ü¤è¶ô¡A·Q½Ð±Ð¦³§Oªº¤èªk¥i¥H­pºâ¥Xµ²ªG¦ý¬O¤S¤£·|¥X²{¹ï¸Ü¤è¶ôªº¤èªk¶Ü¡HÁÂÁÂ

¤£¦n·N«ä½Ð°Ý¤@¤U¨S§Oªº¤è¦¡¤F¶Ü¡H

TOP

evaluate¨ç¼Æ¥Î±o«Ü¼sªx¡A¦ý¨SÅ¥¹L¦³¦¹²{¶H¡C

TOP

¥i¯àÁÙ¬O­n¥Î¨ä¥L¤è¦¡¨ÓÂà´«¤å¦r­pºâ¡A·PÁ¦^ÂÐ

TOP

=LEFT(A1,FIND("/",A1)-1)/RIGHT(A1,LEN(A1)-FIND("/",A1))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

·PÁÂHsiehª©¥D¸Ñ¨M¡A¯u¬O¼F®`§Ú·Q¯}ÀY³£¨S·Q¨ì¡A¦A¦¸ÁÂÁÂ

TOP

¦^´_ 5# Hsieh
=LEFT(A1,FIND("/",A1)-1)/RIGHT(A1,LEN(A1)-FIND("/",A1))
¦n¥Î
¦ý¦pªG¬O 99/12/15
«ç»ò¨ú 99   12   15
HI

TOP

¦^´_ 7# mycmyc
³o´NÅܦ¨¤é´Á®æ¦¡  ½Ð¨Ï¥Îyear(),month(),day()

TOP

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