Formatting Numbers

VBA provides several functions that you can use to format numbers: FormatNumber, FormatCurrency, FormatPercent, and Format.
All of these functions return a number formatted as a string.

FORMATNUMBER

The FormatNumber function formats a number with the comma as the thousands separator.

FORMATCURRENCY

The FormatCurrency function formats a number with a dollar sign, including two decimal places by default.

FORMATPERCENT

The FormatPercent function formats a number as a percentage, including two decimal places by default.

FORMAT

The Format function to specify a custom format if you need a very specific number format.