«Ü¦h¤½¥q³£·|¨Ï¥ÎExcel¨Ó½s¼g³æ¾Ú¡A«Ü¦h®É¶¡³£»Ýn±Nªü©Ô§B¼Æ¦rÂà´«¦¨¤¤¤å©Î^¤å¤j¼g¡C¨ä¹êExcel¤w¤º¸m¤F¤¤¤å¤j¼gÂà´«ªº®æ¦¡¡A¾Þ§@«D±`²³æ¡A¦bÀx¦s®æ¤W¿é¤J¼Æ¦r«á¦A¥Î·Æ¹«¥kÀ»¡A¦b¿ï³æ¿ï¡uÀx¦s®æ®æ¦¡¡v¡A¿ï¡u¼Æ¦r¡v¶±¡A¦A¿ï¡uÃþ§O¡v¤U±ªº¡u¯S®í¡v¡AµM«á¦b¥k°¼ªº¡uÃþ«¬¡v¤U¿ï¾Ü¤j¼g®æ¦¡¡A³Ì«á«ö¡u½T©w¡v´N·|¦Û°ÊÂର¤j¼g¤F¡C
¦ý¦pªG¤j®a·Q±N¤p¼gª÷ÃB¡A¦p2138.5Âà´«¬°¤j¼gª÷ÃBªº¶L¥a³ü¨Õ¤T¬B®Ã¤¸¥î¨¤¡A«h»Ýn³q¹L½s¼gVBA¨Ó¹ê²{¡A¨ãÅé¾Þ§@¥i¥H°Ñ¦Ò¹q¸£®É¥NÂø»x(160´Á)¡A¤º¤å¦³¸Ô²ÓªºÁ¿¸Ñ¡A³o¸Ì²²¤Á¿z¤@¤U¡C¥ý°õ¦æExcel¡A¤§«á¿ï¡u¤u¨ã¡v¡u¥¨¶°¡v¡÷¡uVisual Basic½s¿è¾¹¡v¡A³o®É·|¶i¤JVisual Basicªº½s¿èÀô¹Ò¡A¿ï¥\¯àªíªº¡u´¡¤J¡v¡÷¡u¼Ò²Õ¡v¡A§â¡u¦Û°ÊÂà´«¤¤¤å¤j¼gVBAµ{¦¡½X¡vªº¤º®e¤@¤@¿é¤J¨ì¥k¤èµøµ¡ªºªÅ¥Õ³B¡A§¹¦¨«á¦AÀx¦s¡C½sªÌ¤w±N³o¬qµ{¦¡½XÀx¦s¦¨TXT¡A¨ì¥H¤Uªº¹q©ö¸£¥Xª©¶°¹Îªººô§}¤U¸ü©Mª½±µ¨Ï¥Î¡G
http://www.easycomputing.com.hk/code.txt¡C
¦pªG¤j®a¯u¬OÃi±o°Ê¤â¡A¦P¼Ë¥i¥H¨ì³oÓºô§}¤U¸ü½sªÌ»s§@ªºExcel½d¨ÒÀÉ(http://www.easycomputing.com.hk/sample.xls)¡A¶}±ÒÀɮ׮ɰO¦ín¿ï¡u¶}±Ò¥¨¶°¡v¡A§_«hµLªk¥¿±`¶i¦æÂà´«¡C§Q¥ÎÀɮ׸̨âÓ¨ç¼Æ´N¥i¥H»´©öÂà´«¥X¤¤¡B^¤å¤j¼g¤F¡G
=exchange(12356.5)¡G·|Âà´«¥X¡u³ü¸U¶L¥a°Ñ¨Õ¥î¬B³°¤¸¥î¨¤¾ã¡v
=SpellNumber(12356.5)¡G·|Âà´«¥X¡uTwelve Thousand Three Hundred Fifty Six Dollars and Fifty Cents¡v
·íµM¡A³Ì§Ö±¶ªº¤èªk´N¬O¨Ï¥Î§Ú̱À¥Xªº¤ä²¼³q(¹q¸£¤ä²¼¾÷)¨Ó¦C¦L¤ä²¼©MºÞ²z¤ä²¼Ã¯°Õ¡I
¡@
¡@
¡@
¡@
¡@
¡@
¡@
|