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

[µo°Ý] ´Á­­ªº¤é´Á¤p©ó¤µ¤Ñ¡A«e­±ªº¤å¦r¦Û°ÊÅÜÃC¦â?

[µo°Ý] ´Á­­ªº¤é´Á¤p©ó¤µ¤Ñ¡A«e­±ªº¤å¦r¦Û°ÊÅÜÃC¦â?

¦U¦ì¤j¤j¦n
¤p©f·Q¸ß°Ý¤@¤U¦³¨S¦³¥i¯à«´Á­­»(¹Ï¤¤ªº¬õ1)ªº¤é´Á¤p©ó¤µ¤Ñ
(¹Ï¤¤ªº¬õ2)´N¦Û°Ê´«¦¨§OªºÃC¦â©O¡H
ÁÂÁÂ^_^


´ú¸Õ.rar (47.69 KB)

¦^´_ 1# ÄÉ¡C

¦]¬°YÄ椺®e«D¥¿¦¡¤é´Á¥²¶·Âন¤é´Á
®æ¦¡¤Æ±ø¥ó
=--TEXT(Y3+19110000,"###!/##!/##")<TODAY()
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_  ÄÉ¡C

¦]¬°YÄ椺®e«D¥¿¦¡¤é´Á¥²¶·Âন¤é´Á
®æ¦¡¤Æ±ø¥ó
=--TEXT(Y3+19110000,"###!/##!/##")
Hsieh µoªí©ó 2017-8-31 11:05



    ª©¤j±z¦n
    ¦A¸ò±z½Ð±Ð¤@¤U¡A®æ¦¡¤Æ±ø¥ó¬O¦b«Àx¦s®æ®æ¦¡¡÷¦Û­q»¨ºÃä¶Ü¡H

TOP

google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

·PÁ¨â¦ì¤j®v~
§Ú¦¨¥\§¹¦¨¤F~

TOP

        ÀR«ä¦Û¦b : ¨C¤ÑµL©Ò¨Æ¨Æ¡A¬O¤H¥Íªº®ø¶OªÌ¡A¿n·¥¡B¦³¥Î¤~¬O¤H¥Íªº³Ð³yªÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD