View Single Post
  #1   Report Post  
JR
 
Posts: n/a
Default csv converting numbers to scientific format

I've imported a series of numbers and when I save it in csv format, it
changes the numbers to the scientific format unless it's under 10 digits.
I've tried converting to text, multipling by 1, but nothing seems to keep it
formatted as a number? Each time it looks like it will work, I save it and
reopen it, only to find the numbers converted to scientific format again.

I'm completely confused as to why it won't store it as a general number if
over ten digits?
--
JR Wireless