Problem in comma format in export using macro

[udaya_kumar]

Hi,

I have set of 3 straight table, one below another.

I am exporting the tables using macro.

The table has some whole numbers with comma like 4,500 or 15,000.

but after i export it, in excel it shows 4500 or 15000.

There is no comma format applied in excel. what might be the problem?

can someone help?

[Gysbert_Wassenaar]

Export to excel exports only the data, not the formatting. You'll have to add the code for that to the macro yourself. See here for an example.