- ©«¤l
- 186
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 218
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-11-12
- ³Ì«áµn¿ý
- 2014-4-15
|
¦^´_ 7# ML089
¦P·N³oÓÁ¿ªk
§Ú«e±»¡ªº"¥ÎTEXT¨ç¼Æ¡A®æ¦¡´N¸ò§A쥻³]ªº¤@¼Ë§Y¥i"¡A³oÃä«üªº¬O¡uTEXT¨ç¼Æ¤ºªºformat¡v
¦Ü©ó¥ØªºÄæ(CÄæ)ªº®æ¦¡¡Aªº½TÀ³¸Óµø쥻¸ê®Æªº®æ¦¡¨Ó¨M©w¡A¥H³oÃD¨Ó»¡¡A"00000"¦ü¥G¬O«ê·íªº
·Ó²z¨Ó»¡A¡BBÄæ¬O¼Æ¦r¡A¦]¦¹CÄæ¤]¸Ó¬O¼Æ¦r¡A¦]¦¹¥i¥Î- =--(TEXT(A1,"000")&TEXT(B1,"00"))
½Æ»s¥N½X ³B²z
¦Ü©óBÄæ¥X²{3¦ì(¥H¤W)¼Æªº±¡§Î¡Aªº½T·|¸ò쥻¸ê®Æ³]©wªº¤è¦¡¬Û½Ä¬ð
CÄæ¥Î"00000"®æ¦¡ªº¸Ü¤]¦³¥i¯à¥X°ÝÃD(¤ñ¤è»¡A1=001¡AB1=123¡A«h
C1=--(TEXT(A1,"000")&TEXT(B1,"00"))=1123¡A¨Ì®æ¦¡Åã¥Ü´N·|¬O01123¦Ó¤£¬O001123
¤£¹L·íµMÁÙ¬On¬Ýìpoªº»Ý¨D¦Ó©w |
|