How to display the whole number instead of exponential number format
Can someone tell me how to convince a CSV file saved with the string “88888887039546656102802″ to not turn into an exponential number "8.88888870395466E+22" ? when i load the CSV and reads the exponential number "8.88888870395466E+22" instead of the act开发者_JAVA技巧ual value “88888887039546656102802″.
And after which limit csv convert number into exponential format
how can i avoid this?
Thanks!
On excel you may choose input method as text by right click column Select FormatCells select text format.
精彩评论