ªð¦^¦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"),"/",)  ¦n´ÎªºªF¦è
¦æ±o³q
¦ý¦³¨S¦³¨ä¥L¤è¦¡©O? ¦pªG¸ê®Æ¦n´X¸Uµ§¶Ã©Ô¨ì¤âµm==

TOP

        ÀR«ä¦Û¦b : ¥@¤W¦³¨â¥ó¨Æ¤£¯àµ¥¡G¤@¡B§µ¶¶ ¤G¡B¦æµ½¡C
ªð¦^¦Cªí ¤W¤@¥DÃD