VB Formatº¯Êý
Format[$] ( expr [ , fmt ] )
format ·µ»Ø±äÌåÐÍ
format$ Ç¿ÖÆ·µ»ØÎªÎı¾
--------------------------------
Êý×ÖÀàÐ͵ĸñʽ»¯
--------------------------------
¹Ì¶¨¸ñʽ²ÎÊý£º
General Number ÆÕͨÊý×Ö£¬Èç¿ÉÒÔÓÃÀ´È¥µôǧλ·Ö¸ôºÅ
format$("100,123.12","General Number") ·µ»ØÖµ 100123.12
Currency »õ±ÒÀàÐÍ£¬¿ÉÌí¼Óǧλ·Ö¸ôºÅºÍ»õ±Ò·ûºÅ
format$("100123.12","Currency") ·µ»ØÖµ £¤100,123.12
Fixed ¸ñʽΪ´øÁ½Î»Ð¡ÊýµÄÊý×Ö
format$("100123","Fixed") ·µ»ØÖµ 100123.00
Standard ±ê×¼£¬¼´´øÇ§Î»·Ö¸ôºÅºÍÁ½Î»Ð¡Êý
format$("100123","Standard") ·µ»ØÖµ 100,123.00
Percent °Ù·ÖÊý
format$("100123","Percent") ·µ»ØÖµ 10012300.00%
Scientific ¿ÆÑ§¼ÇÊý·¨
format$("100123","Scientific") ·µ»ØÖµ 1.00E+05
Yes/No µ±ÖµÎª0ʱ·µ»Ø NO,·ñÔò·µ»Ø YES
format$("100123","Yes/No") ·µ»ØÖµ Yes
True/False µ±ÖµÎª0ʱ·µ»Ø False,·ñÔò·µ»Ø True
format$("100123","True/False") ·µ»ØÖµ True
On/Off µ±ÖµÎª0ʱ·µ»Ø Off,·ñÔò·µ»Ø On
format$("100123","Yes/No") ·µ»ØÖµ On
×Ô¶¨Òå¸ñʽ²ÎÊý
"" ²»½øÐиñʽ»¯ ·µ»ØÖµ ÔÖµ
0 ռλ¸ñʽ»¯£¬²»×ã²¹0
format$("100123","0000000") ·µ»ØÖµ 0100123
# ռλ¸ñʽ»¯£¬²»×ãʱ²»²¹0
format$("100123
Ïà¹ØÎĵµ£º
×ö±ÏÒµÂÛÎĵÄʱºòÓöµ½µÄÒ»¸öÎÊÌ⣬Çë½Ì¶¹°êÉϵÄÍøÓѲÅÓÐÁ˴𰸡£Ð»Ð»Õâλ½Ð“Òì²Ê”µÄÅóÓÑ¡£ÄóöÀ´Óë´ó¼Ò·ÖÏí¡£
¡¡¡¡ÓÃVB×öͼÏñ´¦ÀíÈí¼þµÄ±ÏÒµÂÛÎÄ£¬Óöµ½Ò»¸öÎÊÌâ¡£¼ÓÔØÒ»·ùͼƬ£¬Óöà¸öÂ˾µ·Ö±ð´¦Àí£¬ÏëÒ»²½Ò»²½UNDOµ½×îÔʼµÄͼÏñ£¬¶à´ÎUNDOÔõôʵÏÖ?
²Î¿¼·½°¸£º
Èç¹ûÏë×öµ½¶à´ÎUND ......
·´íÎóÀàÐÍ
·±à³ÌÔ±µÄ´íÎ󣨱ÈÈç·Öĸ²»ÄÜÊÇ0£¬²ÎÊý¸öÊý»òÊý¾ÝÀàÐͲ»¶ÔÓ¦£©
·»·¾³·½ÃæµÄ´íÎ󣨱ÈÈçÎļþÌ«´ó£¬´ÅÅ̷Ų»Ï£©
·Ê±¼äÉϵĴíÎ󣨱ÈÈçÊÓͼ¸øÉÐδÍê³É¼ÓÔØµÄ´°ÌåÉèÖý¹µã£©
·´´½¨´íÎó´¦Àí³ÌÐò
......
·½çÃæÉè¼Æ±ØÐë±£³ÖÒ»ÖÂ
·Á½¸ö³ÌÐòÖ®¼äµÄÌØÐԾ߱¸¹²ÐÔ
·ºÍwindowsÓ¦ÓóÌÐòµÄ¿ì½Ý¼üÊÇÒ»ÖµÄ
·±à³ÌÔÔò
·Îª´°Ì帳ÓèͳһµÄÍâ¹ÛºÍÐÐÎªÌØÐÔ
·Èç¹û´°ÌåµÄ´óС¸Ä±äʱ£¬Ëü²»¸Ä±äÆäÄÚÈݵĴóС£¬ÄÇô±ß¿ò¾Í²»Ó ......
×òÌìÍíÉÏ£¬Ã×ÀÏʦ°ÑÎҽе½°ì¹«ÊÒ¡£ÎÊÎÒѧÁËÒ»ÖܸоõÈçºÎ£¬ÎÒµ±Ê±ºÜº¹ÑÕ¡£Ã×ÀÏʦÉíÌå²»ºÃ£¬µçÄÔ°æ°àô¶àѧÉú£¬Ëû¿ÉÒÔÈÃ×Ô¼ºÇáËÉÒ»µã¶ù£¬µ«ËûûÓС£×÷Ϊ¼¸Ê®¸öѧÉúµÄÃâ·ÑÀÏʦ£¬×öΪÈ˸¸ÈË·ò£¬ÀÏʦÉÐÇÒÖªµÀÎÒѧÁËÒ»ÖܳɹûÔõÑùÄØ£¬µ«ÎÒ×Ô¼ºÈ´Ã»ÓÐÏë¹ý£¬ºÜ²ÑÀ¢¡£·¸ÈκδíÎóµÚÒ»´Î¿ÉÒÔÔÁ£¬µ«¾ø²»Ó¦¸ÃÈÃËü³öÏÖµÚ¶þ´Î£¬Ñ§ÁËÒ»ÖÜ£¬ ......