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?
TIA
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?
VBA Code:
Range("I4:I50").NumberFormat = "0.00"
TIA