Type of data passed to excel

vulkoingim

I have fields with entries that consist only of numbers and when i save that data to excel they get concatenated e.g.: "4.04529E+17
" . Is there a way to specify the type of the data being passed from the column, so i don't have to change the cell type manually in excel after that?

allan

Please link to a test case showing the issue. I suspect this is Excel formatting a number and the raw data actually does contain the full number, but without a test case, I have no way of knowing for sure.

Allan

vulkoingim

The issue is in Excel, i can see the full number when i select the table cell, but when printing it is still concatenated and i have to manually change the cell type to Text in order to show the correct value. My idea is if there is a way to tell Excel to treat the passed data as text/string/whatever excel calls it, without having to make those changes manually afterwards, since it is very inefficient for large data sets. Here is a fiddle, though i could not get TableTools to work there, you can still use the data to see the issue.

http://jsfiddle.net/vulkoingim/uZPqR/

allan

> if there is a way to tell Excel to treat the passed data as text/string/whatever excel calls it

If there is, I'm not aware of it. Any suggestions for how to do that are welcome.

Allan

vulkoingim

After some searching/reading i found this: http://support.microsoft.com/kb/214233
There are several options, and what i chose is to prefix my results with " " and it works like a charm :)

Cheers,

Alex