Format Function

Microsoft® Visual Basic® for Applications (VBA) provides several functions that you can use to format numbers, including the FormatNumber, FormatCurrency, FormatPercent, and Format functions. Each of these functions returns a number formatted as a string. The FormatNumber function formats a number with the comma as the thousands separator. ................
................