开发者

How to display the whole number instead of exponential number format

开发者 https://www.devze.com 2023-01-29 20:53 出处:网络
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 exp

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.

0

精彩评论

暂无评论...
验证码 换一张
取 消