- ©«¤l
- 2025
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 2053
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- Office2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¥«
- µù¥U®É¶¡
- 2011-3-2
- ³Ì«áµn¿ý
- 2024-3-14
|
¦^´_ 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 |
|