Change number format to comma separator with decimals using VBA?

[Mr2017]

Hi

I currently change the number format of a column so that it has 2 dp.

However, I would like to include the comma separator, so that if there are numbers over 1000 then they will appear as 1,000.00

Does anyone know how to change the code below, please?

Range("I4:I50").NumberFormat = "0.00"

TIA

 

[davesexcel]

Just use your macro recorder to see what the code looks like.

Sub Macro2()
'
' Macro2 Macro
'

'
    Range("I4:I50").Select
    Selection.NumberFormat = "#,##0.00"

After you clean it up
Range("I4:I50").NumberFormat = "#,##0.00"

 

[Mr2017]

Ah, yes!

Yes, that's a good idea!

And that worked!

Thank you!