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

[µo°Ý] FORMAT¤½¦¡

[µo°Ý] FORMAT¤½¦¡

¦U¦ì¤j¤j,§Ú·Q½Ð±Ð¤@­Ó°ÝÃD,§Ú¦b¾ÇVBA®É,¦bµ{¦¡¤¤¾Ç= Format(Now, "yyyy-m-dd"),¥i¥HÅã¥Ü2014-1-22,¦ý­Y§â¤½¦¡¼g¤J¤u§@ªíªºÀx¦s®æ,´N·|Åܦ¨#NAME?,³o¬O¤°»ò­ì¦]©O?

=TEXT(NOW(), "yyyy-m-dd")

À³¸Ó¬O§A»Ý­nªº§a

TOP

¦^´_ 2# louts
·PÁÂlouts¤jªº¦^ÂÐ,

©Ò¥H=format(now(),"yyyy-mm-dd")¤£ºâexcel¨ç¼Æ,¬Oµ{¦¡½X,¥u¯à¼g¦bVBA¸Ì?

TOP

        ÀR«ä¦Û¦b : ¤£©È¨Æ¦h¡A¥u©È¦h¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD