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

[µo°Ý] ¦p¦ó¨Ï¥ÎTEXT¨ç¼ÆÂà´«¼Æ¦r®æ¦¡(¦p¡u8¡v¤ë¡÷¡u¤K¡v¡B¡u2013¡v¦~¡÷¡u102¡v)

[µo°Ý] ¦p¦ó¨Ï¥ÎTEXT¨ç¼ÆÂà´«¼Æ¦r®æ¦¡(¦p¡u8¡v¤ë¡÷¡u¤K¡v¡B¡u2013¡v¦~¡÷¡u102¡v)

¥»©«³Ì«á¥Ñ p212 ©ó 2013-8-20 09:45 ½s¿è

¥HTODAY­Èµ¥©ó2013/08/20¬°¨Ò¡G
¤À§O¨Ï¥ÎYEAR(TODAY())»PMONTH(TODAY())¡AÂà´«¡u¦~¡v¡B¡u¤ë¡v­È±o¡u2013¡v¡B¡u8¡v¡C
¤µ±ý·f°t¨Ï¥ÎTEXT¨ç¼Æ ( §YTEXT(YEAR(TODAY()),format_text) )¡A½Ð°Ý­n¦p¦ó«ü©wformat_text¤~¥iÀò±o¦~­È¬°¡u102¡v¡B¤ë­È¬°¡u¤K¡v¡H
·Ð½Ð¦U¦ì«e½ú«ü¾É¡AÁÂÁ¡I

=TEXT(MONTH(TODAY()),"[dbnum1]")
=TEXT(TODAY(),"e")

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2013-8-20 13:42 ½s¿è

¦^´_ 2# ANGELA
«D±`·PÁª©¥D«ü¾É¡I
1¡B½Ð±Ð"[dbnum1]"¦bExcelªº»¡©úÀɤº«ç»ò¬d±o¡H(¥ý«e©óTEXT¨ç¼Æ¤§»¡©ú»P¨ä¬ÛÃö³sµ²¤º§¡¥¼´£¤Î)
2¡B¤S¦~Âà´«¬°¦ó¤£¥i¦p¤ëÂà´«¨Ï¥Î=TEXT(YEAR(TODAY()),"e")¡H©ó¦ó³B¥i¾Ç±o¦¹³Z¬¡H

TOP

¦^´_ 3# p212


    EXCELªº»¡©ú¨Ã¤£¸Ô²Ó,¦h¤W°Q½×ª©¤~¯à¾Ç¨ì§Þ¥©
      =YEAR(TODAY())-1911
    ¥¿¦¡¨ç¼Æ¬O=TEXT(TODAY(),"E/M/D")
    E ¥Á°ê¦~¥÷
       y ¦è¤¸¦~¥÷

TOP

¦^´_ 4# ANGELA

³o¬OÃö©ó Excel Àx¦s®æ®æ¦¡ ªº¾Ç²ß¡A¦pªG§A·Qª¾¹D§ó¦hªº¼Æ­È®æ¦¡¡A¥i¥H°Ñ¦Ò TQC Excel 2010 ¯S°V±Ð§÷¤¤²Ä13³¹-¯S®í®æ¦¡³]©w¡A¬Û«H§A·|«Ü³ßÅw!!!

TOP

¦è¤¸¦~´«ºâ¥Á°ê¦~³£·|¥Î-1911¡A¨S·Q¨ìÁÙ¥i³o¼Ë¥Î¡A¼F®`¡AexecelÁÙ¦³ªº¾Ç

TOP

¦³¯qªº§®©Û¡A¦h¾Ç°_¨Ó

TOP

¦³¯qªº§®©Û
¤@¦Ê¤­¤Q¥|        '=TEXT("154","[dbnum1]")
³ü¨Õ¥î¬B¸v        =TEXT("154","[dbnum2]")
¾Ç¨ì¤F,ÁÂÁÂ
lmh

TOP

±`±`³£»Ý­n¹ïÀ³¦è¤¸©M¥Á°êªº¼Æ¦r
¦ý¬O¹ïÀ³¤U¥h³£·|Åܦ¨¤d¦ì¼Æ
³o½g¤ñ¸û¤F¸Ñ­ì²z¤F¡A·PÁÂ~

TOP

Ãþ¦ü©µ¦ùªº·|­p¤Wª÷ÃB¤p¼gÂà¤j¼g¤]¦³¦P¼Ëªº¥Îªk,ª©¤W¤w¦³¦h­Ó½d¨Ò¥i°Ñ¦Ò!!

TOP

        ÀR«ä¦Û¦b : ¥¬¬I¦p¼½ºØ¡A¥HÅw³ß¤ß´þ¼íºØ¤l¡A¤~·|µoªÞ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD