[µo°Ý] ¤é´ÁÂ^¨ú°ÝÃD

cubela

½Ð°Ý¦pªG·Q§â¤é´ÁÂ^¨ú·í¦¨½s½X¡A­n¦p¦ó¨Ï¥Î¨ç¼Æ©O?

¨Ò¦p
¬Y­ÓÀx¦s®æªº¤é´Á
2014¦~08¤ë23¤é
ºI¨ú¸Ó¤é´ÁÅܦ¨¡÷102384

ÁٽиѴb¡A·P¿E¤£ºÉ

p212

¦^´_ 1# cubela
°²³]¤é´Á¸ê®Æ¦ì©óÀx¦s®æA1¬°¡u2014¦~08¤ë23¤é¡v¡AÀx¦s®æB1¿é¤J
=LEFT(TEXT(A1,"YY"),1)&LEFT(TEXT(A1,"MM"),1)&TEXT(A1,"DD")&RIGHT(TEXT(A1,"MM"),1)&RIGHT(TEXT(A1,"YY"),1)
½Ð°Ñ¦Ò¡I

red

¦^´_ 1# cubela

¤p§Ì¨Ï¥Î¤è¦¡¡G

    =CONCATENATE(MID(YEAR(A2),3,1),MID(IF(LEN(MONTH(A2))=1,CONCATENATE(0,MONTH(A2)),MONTH(A2)),1,1),IF(LEN(DAY(A2))=1,CONCATENATE(0,DAY(A2)),DAY(A2)),MID(IF(LEN(MONTH(A2))=1,CONCATENATE(0,MONTH(A2)),MONTH(A2)),2,1),MID(YEAR(A2),4,1))

ML089

¦^´_ 1# cubela


    =SUM(MID(TEXT(A1,{"yy";"mm";"dd"}),{1,2},1)*10^{5,0;4,1;3,2})

p212

¦^´_ 4# ML089
·PÁª©¤j¶Ç±ÂÄ_¶Qªº¤@½Ò¡Aºë±mªºµu¤½¦¡¡AÁÂÁ¡I
ps. «Øij¦U¦ì¦P¦n¥i§Q¥Î¡u¤½¦¡½]®Ö¡v¤§¡uµû¦ô­È¤½¦¡¡vªº¥\¯à¬Ý¨£¤½¦¡­åªR»P¹Bºâ¹Lµ{

cubela

·PÁ¦U¦ì¤j¤j~~
¯uªºÄ±±o¦U¦ìªºÅÞ¿è³£«Ü¦n­C(Æg!!!)

mmxxxx

¦^´_ 4# ML089

¤j¤j,

¬Ý¦n¤[, ¥i¬O¤£À´, ½Ð«ü¾É, »¡©ú¤@¤U.
TEXT(value, format_text) --> Format_text ¤£¬O­n¥ÎÂù¤Þ¸¹¶Ü? «ç·|¬O{"yy";"mm";"dd"}
±µµÛ«á­±±µªº, §ó¬O¬Ý没¦³À´, ¦n¹³µL¦r¤Ñ®Ñ.

ML089

¦^´_ 7# mmxxxx

¦pªG§A¥H«e§¹¥þ¨S¦³¥Î¹L°}¦C¤½¦¡½T¹ê·|¬Ý¤£À´¡A§Ú¤]«ÜÃø²³æ´X¥y´N»¡©ú²M·¡¡]§Ú±o»y¤å¯à¤O¤ñ¸û®t¤@¨Ç¡^¡A§Ú¥ý²³æ»¡©úµ¥§Ú¦³ªÅ¦A²Ó»¡¡A©Î¨º­Ó°ª¤â¤]¥i¥H¥N¬°»¡©ú¡C
=SUM(MID(TEXT(A1,{"yy";"mm";"dd"}),{1,2},1)*10^{5,0;4,1;3,2})

{"yy";"mm";"dd"} ¬°««ª½°}¦C¤å¦r¡A
·í A1="yy", A2="mm", A3="dd" ®É¡AA1:A3´Nµ¥©ó {"yy";"mm";"dd"}

A1=2014/08/25
TEXT(A1,{"yy";"mm";"dd"}) = {"14";"08";"25"}
´N¬O¤U¦C¤T¦¡ªº°}¦C²Õ¦X¦¡¡]««ª½±Æ¦C¡^
TEXT(A1,"yy") = "14"
TEXT(A1,"mm") = "08"
TEXT(A1,"dd") = "25"

¦A¥Î MID¡]...., {1,2},1) ©î¦¨ 2 Äæ, ¦b­¼©ó©Ò¹ïÀ³ 10^{5,0;4,1;3,2}¡A³Ì«áÁ`¥[´N¬Oµª®×
"1","4"              5, 0
"0","8"   * 10^ 4, 1
"2","5"              3, 2

100000, 000004
000000, 000080
002000, 000500

¥H¤W¼Æ¦r(«e­±¸É0¬O¤è«Kµ¹§AÆ[¹î)¥[Á` 102584

mmxxxx

¦^´_ 8# ML089


²×©ó¤F¸Ñ, ·PÁ¤j¤j¸Ô²Ó¸Ñ»¡,
¯u¬O°ª¤â, ¯«¤H.
·PÁÂ.Åý§Ú·PıÀò¯q¨}¦h.