Read Excel - How to keep origianl format?

[itmonster999]

I use “Excel Application Scope” to read a worksheet and save to a Datatable, in Column A & B should include “#N/A”.
However, after i exporting this datatable, all “#N/A” changed to “-2146826246”.

May i know how to prevent this?

[etss1016 (Tao Tang)]

You can invoke vb.net code to setting cell’s format