Last post Mar 14, 2010 10:04 PM by mbanavige
Mar 14, 2010 04:54 PM|fgeorge|LINK
I'm not to sure if this is the right forum for this but i have a bit of code that exports data in a datagrid into excel but i noticed that it messes up a particular field when exporting. eg ..
i have the value of something like 89234010000725515875 in a column in the datagrid but when exported, it turns it into 89234+19.
Is there any excel formatting that will bring back my original number?
excel export datagrid float
Mar 14, 2010 10:04 PM|mbanavige|LINK
you could prefix the data with a single quote
or you could use a library like NPOI to take more control over the resulting xls