Export to Excel with long number

doggy · January 15

When I export to Excel, if the data type is long, the output number will be in scientific notation. I wonder if there is any way to force the export of long to be in string format as well? Or is it possible to provide a option that can control the output format preference?

i2van · January 15

You can format cell in Excel itself (default one is General, which has no specific number representation). It can be also done via Excel interop.

JoeAlbahari · January 16

If the number should be treated as a string, call .ToString() before exporting. Excel will then show you all the digits without trying to format it.

Export to Excel with long number

Comments

Categories