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

[µo°Ý] ¦p¦ó±N¤å¦r¤Î°Ñ·Ó¦P®É©ñ¦b¤@­ÓÀx¦s®æ¤¤¡H

[µo°Ý] ¦p¦ó±N¤å¦r¤Î°Ñ·Ó¦P®É©ñ¦b¤@­ÓÀx¦s®æ¤¤¡H

¥»©«³Ì«á¥Ñ Trank ©ó 2011-11-3 00:06 ½s¿è

¦pªþ¥ó©Ò¥Ü¡A¦p¦ó±N¤å¦r "¹w¦ô©|»Ý°Ê¤äª÷ÃB" ¤Î°Ñ·Ó "=B2" ¦P®É©ñ¦bÀx¦s®æ A1 ¤¤¡H
¦p¦ó­×§ïÀx¦s®æ A1 ¤¤¤§¤å¦r¡H

¸Õºâªí.rar (1.95 KB)

¥»©«³Ì«á¥Ñ binargoo ©ó 2011-11-3 17:03 ½s¿è

¦^´_ 1# Trank


    ³o¬O§A­nªº¶Ü¡H
    §Ú¥u·|³o¨Ç¡A¦pªG¤£¬O«h½Ð¨ä¥L«e½úÀ°¦£¡C



¸Õºâªítest.rar (2.22 KB)
¥u¬°¾Ç²ß©Ò¥Hµo°Ý

TOP

¥»©«³Ì«á¥Ñ jennylu520 ©ó 2011-11-3 13:28 ½s¿è

±N A1 Àx¦s®æ ¿é¤J  ="¹w¤°©|»Ý°Ê¤äª÷ÃB¡G"&B2

(Åã¥Ü = ¯S©w¤å¦r + ¯S©wÀx¦s®æ)

TOP

¦^´_ 3# jennylu520


    ¤£·|§a¡H¤U¸ü2¼ÓÀɮ׸ոթÎÀɮ׶ǤW¨Ó¡C
¥u¬°¾Ç²ß©Ò¥Hµo°Ý

TOP

jennylu520 ªº¤èªk¥i¥Î¡A¦ý»P¥»¤H­ì©Ò¤W¶Ç¤§¤è¦¡¤£¦P¡A
§Y¸ê®Æ½s¿è¦C¶ÈÅã¥Ü°Ñ·Ó¡A¨ÃµL¤å¦r¡C
¦p¦ó§¹¦¨¥»¤H­ì©Ò¤W¶Ç¤§¤è¦¡¡H

TOP

¦^´_ 5# Trank


    ¸Õ¸Õ


¥u¬°¾Ç²ß©Ò¥Hµo°Ý

TOP

¦^´_ 5# Trank


    §Aªº¤è¦¡¬O³z¹L®æ¦¡³]©w¹F¦¨
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¶â¡Aª©¥DªGµM¤@¥X¤â¡A´N¸Ñµª©Ò»Ý~~
¥Î¦Û­qªº¤è¦¡¥h«Ø¥ß¡A¤£ºÞ¿é¤J¤°»òª÷ÃB¡A´N¥i¥H±o¨ì­nªºµ²ªG¤F

§Ú¤]¦³¥Î¹LÀx¦s®æ®æ¦¡¦Û­qªº¥\¯à¡A¦b³o©~µM¨S·Q¨ì­n¥Î¡A«¢

TOP

¶W¯Åª©¥D¤§¤èªkªº½T§Y¬O°ÝÃD¤§¸Ñµª¡A¤£¹L©|¦³¤@°Ý¡G
¦p¦ó±N¤å¦r¤Î¼Æ¦r¤§¦r«¬¤À§O³]©w¬°¼Ð·¢Åé¤ÎTimes New Roman¡H

TOP

®@¡A³o­Ó¦r«¬ªº°ÝÃD´NÃø¤F~~
¤¤¤å¥i¥HÅܦ¨¼Ð·¢Åé¡A¼Æ¦r¥i¥HÅÜTimes New Roman
·íÀx¦s®æ¦³¤å¦r¡B¼Æ¦r¡A¤@¯ë·|µø¦P¨t²Îªº³Ì«á¤@­Ó¿ï¶µ~~
³o­Ó°ÝÃD¤Ó§®¤F¡A¦³¸Ñªº¸Ü¡A§Ú¤]­n¾Ç~~

¥t¥~¡A·Q°Ý Hsieh ¶W¯Åª©¥D:
Àx¦s®æ³]©w ¦Û­q
"¹w¦ô©|»Ý°Ê¤äª÷ÃB:"#,##0
»P
"¹w¦ô©|»Ý°Ê¤äª÷ÃB:"#,###
¨âªÌªºµ²ªG¤@¼Ë¡A
³Ì«á¤@½X¥Î 0 ©M # ¦³¤°»ò¯S§O±¡ªp¤U·|¦³®t²§©O¡H

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦pÆp¥Û¡j®É¶¡¹ï¤@­Ó¦³´¼¼zªº¤H¦Ó¨¥¡A´N¦pÆp¥Û¯ë¬Ã¶Q¡F¦ý¹ï·M¤H¨Ó»¡¡A«o¹³¬O¤@§âªd¤g¡A¤@ÂI»ù­È¤]¨S¦³¡C
ªð¦^¦Cªí ¤W¤@¥DÃD