numbers truncating
I have exported a file as a .csv file and when I open it in Excel the numbers
truncate ( I think that's what they're doing) ex. 5193571568 chages to
5.195E+09. I have changed the formatting of the column to text and it still
happens. It looks fine if I expand the column but the problem is when I save
the file, it automatically shrinks again when I save as a csv file. Any
suggestions how to keep the numbers?
|