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

[µo°Ý] ¸ß°ÝEXCEL¦Û­q®æ¦¡~~

[µo°Ý] ¸ß°ÝEXCEL¦Û­q®æ¦¡~~

¦U¦ì°ª¤â¦n
·Q½Ð°Ý¦bEXCEL·í¤¤¡A¦b¦Û­q®æ¦¡¤¤¥Î«#"-"#","#»
·í¿é¤J3­Ó¼Æ¦r¡A¤ñ¦p567¡A«5-6,7»
¦ý¦pªG7Åܦ¨17ªº®É­Ô¡A·|Åܦ¨«56-1,0»
·Q½Ð°Ý¦³¨S¦³®æ¦¡¦³¿ìªk°t¦X³Ì«á¤@®æ¼Æ¦rÅܦh©O¡H
¦]¬°¥u¦³³r¸¹«áªº¨º­Ó¼Æ¦r·|Åܦ¨2¦ì¬Æ¦Ü¬O3¦ì

¥Î¤½¦¡ªº¸ÜÁÙ¯à·Q¨ì,¥Î¦Û­q®æ¦¡ªº¸Ü´NÃø¤F,¦Û©w®æ¦¡À³¸Ó¬Oº¡¨¬«á­±¨º­Ó¦ì¼Æ¥ý,©Ò¥H¦³¦h¦³¤Ö·|¤ÏÀ³¦b«e­±

TOP

¥Î¤½¦¡ªº¸ÜÁÙ¯à·Q¨ì,¥Î¦Û­q®æ¦¡ªº¸Ü´NÃø¤F,¦Û©w®æ¦¡À³¸Ó¬Oº¡¨¬«á­±¨º­Ó¦ì¼Æ¥ý,©Ò¥H¦³¦h¦³¤Ö·|¤ÏÀ³¦b«e­±
fengetianxia µoªí©ó 2017-8-8 15:47



    ±z¦n¡A¬Oªº~¦pªG¦b«á­±¥[«#»ªº¸Ü¡A·|¤ÏÀ³¨ì«e­±
    ¨º¦pªG³o­Ó°ÝÃD¥Î¤½¦¡ªº¸Ü¡A±z¦³¤°»ò«Øij¥i¥Hµ¹§Ú¶Ü¡HÁÂÁÂ~~

TOP

¤½¦¡ªº¸Ü´NÃþ¦ü³o¼Ë

=TEXT(A2,"«#-#\,"&REPT("#",LEN(N12)-2)&"»")

TOP

¥»©«³Ì«á¥Ñ ­ã´£³¡ªL ©ó 2017-8-8 16:48 ½s¿è

Á`¬OÅܶýX??? [>9999]"«"#-#!,###"»";[>999]"«"#-#!,##"»";"«"#-#!,#"»"

TOP

¦^´_ 5# ­ã´£³¡ªL

¨S¦³·Q¨ì³o­Ó¤è¦V,Æg¤@¤U

    ¤£¹L¦pªG¦³«Ü¦h¦ìªº¸Ü,¦CÁ|¤£§¹§a,¦pªG¬O³oºØ±¡ªp,¦³¤°»ò¿ìªk¶Ü

TOP

¦^´_ 6# fengetianxia


®æ¦¡³]©w¦³¨ä­­«×, ¶W¹L¤F¥u¯à¥Îvba¥h³B²z!

TOP

¤½¦¡ªº¸Ü´NÃþ¦ü³o¼Ë

=TEXT(A2,"«#-#\,"&REPT("#",LEN(N12)-2)&"»")
fengetianxia µoªí©ó 2017-8-8 16:25


Á`¬OÅܶýX??? [>9999]"«"#-#!,###"»";[>999]"«"#-#!,##"»";"«"#-#!,#"&raq ...
­ã´£³¡ªL µoªí©ó 2017-8-8 16:44



    ·PÁ°ª¤â«üÂI><¡A§Ú¶¶§Q§¹¦¨¤F~~~

TOP

        ÀR«ä¦Û¦b : «Ý¤H°h¤@¨B¡A·R¤H¼e¤@¤o¡A´N·|¬¡±o«Ü§Ö¼Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD