
You can separate
“numbers into 3-digit commas”!

Use the following function:
Format Function
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
Result
You separated “numbers into 3-digit commas”!

FYI
For more information about following, see the following official online manual:
●Format Function