VBç¨åºè®¾è®¡æ¶å¯ä½¿ç¨Format å½æ°å®ç°ã
Format å½æ°ï¼è¿å Variant (String)ï¼å
¶ä¸å«æä¸ä¸ªè¡¨è¾¾å¼ï¼å®æ¯æ ¹æ®æ ¼å¼è¡¨è¾¾å¼ä¸çæ令æ¥æ ¼å¼åçã
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/7af40ad162d9f2d36b62f596afec8a136327cc5c?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/4ec2d5628535e5dd792274a670c6a7efce1b62b9?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
Format å½æ°ç¤ºä¾
' ç¨æ·èªå®ä¹çæ ¼å¼ã
Dim MyStr
MyStr = Format(5459.4, "##,##0ã00") ' è¿å "5,459.40"ã
MyStr = Format(334ã9, "###0ã00") ' è¿å "334.90"ã
MyStr = Format(5, "0.00%") ' è¿å "500.00%"ã
MyStr = Format("HELLO", "<") ' è¿å "hello"ã
MyStr = Format("This is it", ">") ' è¿å "THIS IS IT"ã