Number format

[Aland2929]

I am using the following code. When the numbers are in millions, I get the following result - 11636 543 instead of 11 636 543?

Please Login or Register  to view this content.

Thanks in advance

[Aland2929]

I have changed the code and it seems to work.

With ActiveSheet.PivotTables("PivotTable1").PivotFields(" ")
.Calculation = xlNormal
.NumberFormat = "### ##0"
End With

[smuzoen]

Use

Please Login or Register  to view this content.

[Aland2929]

Thank you.