how to format a number - thousands seperator with NO decimal

[dikken20]

Hey,

In VBA code, need to show a number like on the subject:
123456780 ==> 123,456,780

123,456,780.00 --> not good

thanks.

 

[ghrain22]

try

.NumberFormat = "#,##0"

 

[dikken20]

I'm using a msgbox to show a number, so it's not working (or I am doing something wrong),
This is what I did earlier, which shows me 2 decimals:

Format(CLng(bidV3 / 100), "STANDATD")

 

[shg]

What is "STANDATD"?

MsgBox Format(CLng(bidV3 / 100), "#,##0")

 

[dikken20]

What is "STANDATD"?

Meant "STANDARD"

Thanks that works!