Type of data passed to excel
Type of data passed to excel

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?
" . 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?
This discussion has been closed.
Replies
Allan
http://jsfiddle.net/vulkoingim/uZPqR/
If there is, I'm not aware of it. Any suggestions for how to do that are welcome.
Allan
There are several options, and what i chose is to prefix my results with " " and it works like a charm :)
Cheers,
Alex