ªð¦^¦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°µ¤Hªº¶}©l¡j¨C¤@¤Ñ³£¬O¬G¤Hªº¶}©l¡A¨C¤@­Ó®É¨è³£¬O¦Û¤vªºÄµ±§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD