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

¤é´Á+¤å¦r¦p¦ó§e²{

¤é´Á+¤å¦r¦p¦ó§e²{

Àx¦s®æA1¬°2016/1
Àx¦s®æB1·Q­n§e²{
¬õ§Q2016/1©Î2016/1¬õ§Q

=TEXT(A1,"yyyy/mm/dd")&("¬õ§Q")

TOP

¥»©«³Ì«á¥Ñ yen956 ©ó 2016-1-13 15:48 ½s¿è

¦^´_ 1# p0078
Sorry, Pos ¤W«á, ¤~µo²{¤w¦³¤H±¶¨¬¥ýµn(¥B¤½¦¡¤@¼Ë, Sorry)

=TEXT(A1,"yyyy/m/d") & "¬õ§Q"
or
= "¬õ§Q" & TEXT(A1,"yyyy/m/d")

TOP

¥i¥H¤F,·PÁ¤G¦ì

TOP

        ÀR«ä¦Û¦b : ¡i»X½ªªº¦Û¥Ñ¡j¤H±`¦b¤°»ò³£¥i¥H¦Û¥Ñ¦Û¦bªº®É­Ô¡A«o³Q³oºØÀH¤ß©Ò±ýªº¦Û¥Ñ»X½ª¡AµêÂY®É¥ú¦Ó²@µLıª¾¡C
ªð¦^¦Cªí ¤W¤@¥DÃD