The function you need to format percentages is FormatPercent. It is very easy to use and has
been outlined and explained below:
FormatPercent(NumToBeFormatted[, NumOfDigitsAfterDecimal, IncludeLeadingDigit, UseParensForNegativeNumbers])
- returns a formatted percentage from the number specified with the appropriate number
of digits specified after the decimal and a trailing '%' sign.
- the first parameter is the only one that is required, although I recommend that you use
at least include the second parameter.
- the last two parentheses are tristate values which means you need to specify a -1 for true, 0 for false, or -2 to
use the computers regional settings.
- the IncludeLeadingDigit parameter is used to specify whether or not you want a leading
zero to be displayed when the number is a fractional value.
- the UseParensForNegativeNumbers parameter is pretty self explanatory, if set to true
it will put parentheses around negative numbers.
