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?
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.
Retrieving data ...