【VBA】Separate numbers into 3-digit commas

You can separate

“numbers into 3-digit commas”！

Use the following function:
　Format Function

Contents

VBA Code

As an example, Separate “1000000” into 3-digit commas.

Option Explicit

Sub sampleProc()
    'Separate numbers into 3-digit commas
    MsgBox Format("1000000", "#,###")
End Sub

Separate numbers into 3-digit commas(Line 5).

You separated “numbers into 3-digit commas”！

For more information about following, see the following official online manual:

●Format Function