FormatNumber å½æ°
请åé
FormatCurrency å½æ° | FormatDateTime å½æ° | FormatPercent å½æ°
è¦æ±
çæ¬2
è¿å表达å¼ï¼æ¤è¡¨è¾¾å¼å·²è¢«æ ¼å¼å为æ°å¼ã
FormatNumber(
expression [,NumDigitsAfterDecimal [,IncludeLeadingDigit [,UseParensForNegativeNumbers [,GroupDigits]]]]
)
Arguments
Expression
å¿
é项ãè¦è¢«æ ¼å¼åç表达å¼ã
NumDigitsAfterDecimal
å¯é项ãæ示å°æ°ç¹å³ä¾§æ¾ç¤ºä½æ°çæ°å¼ãé»è®¤å¼ä¸º -1ï¼æ示使ç¨çæ¯è®¡ç®æºçåºå设置ã
IncludeLeadingDigit
å¯é项ãä¸æ常æ°ï¼æ示æ¯å¦æ¾ç¤ºå°æ°å¼å°æ°ç¹åé¢çé¶ãæå
³æ°å¼ï¼è¯·åé
â设置âé¨åã
UseParensForNegativeNumbers
å¯é项ãä¸æ常æ°ï¼æ示æ¯å¦å°è´å¼ç½®äºæ¬å·ä¸ãæå
³æ°å¼ï¼è¯·åé
â设置âé¨åã
GroupDigits
å¯é项ãä¸æ常æ°ï¼æ示æ¯å¦ä½¿ç¨è®¡ç®æºåºå设置ä¸æå®çæ°ååç»ç¬¦å·å°æ°ååç»ãæå
³æ°å¼ï¼è¯·åé
â设置âé¨åã
设置
IncludeLeadingDigitãUseParensForNegativeNumbers å GroupDigits åæ°å¯ä»¥æ以ä¸å¼ï¼
å¸¸æ° å¼ æè¿°
TristateTrue -1 True
TristateFalse 0 False
TristateUseDefault -2 使ç¨è®¡ç®æºåºå设置ä¸ç设置ã
说æ
å½çç¥ä¸ä¸ªæå¤ä¸ªå¯é项åæ°æ¶ï¼ç±è®¡ç®æºåºå设置æä¾è¢«çç¥åæ°çå¼ã
注æ
ææ设置信æ¯ååèªåºå设置çâæ°åâéç¾ã
ä¸é¢ä¾åå©ç¨ FormatNumber å½æ°ææ°å¼æ ¼å¼å为带åä½å°æ°ç¹çæ°:
Function FormatNumberDemo
Dim MyAngle, MySecant, MyNumber
MyAngle = 1.3
' ç¨å¼§åº¦å®ä¹è§ã
MySecant = 1 / Cos(MyAngle) ' 计ç®æ£å²å¼ã
FormatNumberDemo = FormatNumber(MySecant,4) ' æ MySecant æ ¼å¼å为带åä½å°æ°ç¹çæ°ã
End Functio
温馨提示:答案为网友推荐,仅供参考