Hi, I got a percentage as "23.343434343%", how can I format to " 23.34%"?<BR><BR>Please help! Thank you very much!
FormatPercent(Expression, NumDigitsAfterDecimal, IncludeLeadingDigit, UseParensForNegativeNumbers, GroupDigit)
I got an error message" Type mismatch: 'formatpercent'"
RTFM: Read The F'n Manual<BR><BR>On the left toolbar there is a link that says "VB Script Reference" Click on it. Find the function that you're looking for, learn how to use it. Bookmark the page and reference that BEFORE you post.