Formatting problem while export to excel

[Anonymous]

Hi All

I am exporting multiple objects through macro to excel.

In excel format has been changed from 10,846,100,200 to 1.085E+10.

Is there a way so I can get the actual 10,846,100,200

I appreciate your help

Thanking all

[m_woolf]

Excel is changing the format of the number because the column isn't wide enough to display it.

You can widen the column in Excel.

[Anonymous]

Thanks Michael, I appreciate your help

[ashfaq_haseeb]

Hi,

It just worked fine with me.

what version of Office you tried with I tried with Office 2013 and it worked.

Regards

ASHFAQ

[Anonymous]

Sorry Ashfaq

I am using MS 2010