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

[µo°Ý] ®É¶¡Âà´«°ÝÃD

[µo°Ý] ®É¶¡Âà´«°ÝÃD

2015/1/1 ¥i¥HÂà´«¦¨20150101
2015/1/2¥i¥HÂà´«¦¨20150102
2015/1/3¥i¥HÂà´«¦¨20150103
2015/1/4¥i¥HÂà´«¦¨20150104
¤@¾ã¦~¥÷

¥i¥H¦Û°ÊÂà´«¦¨¹³¤W­±¨º¼Ë¶Ü?
SQL   .xls ¶×¤J¨ìexcelªº¤è¦¡

©ÎªÌ¦³¤°»ò¤è¦¡¥i¥H¤â½Õ?

=SUBSTITUTE(TEXT(A1,"YYY/MM/DD"),"/",)

TOP

=SUBSTITUTE(TEXT(A1,"YYY/MM/DD"),"/",)  ¦n´ÎªºªF¦è
¦æ±o³q
¦ý¦³¨S¦³¨ä¥L¤è¦¡©O? ¦pªG¸ê®Æ¦n´X¸Uµ§¶Ã©Ô¨ì¤âµm==

TOP

¦^´_ 3# mark761222


=TEXT(A1,"yyyymmdd")

·Æ¹«²¾¨ìÀx¦s®æ¥k¤U¨¤·|¥X²{¶Â¦â¤Q¦r¡A¦A¥ªÁäÂIÀ»¨â¤U·|¦Û°Ê½Æ»s¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¤H­n¦Û·R¡A¤~¯à·R´¶¤Ñ¤Uªº¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD