Cranberries
New Member
- Joined
- Oct 11, 2006
- Messages
- 5
Hi
I have tried to save my excel spreadsheet as a csv file, however, in the columns where I have very long numbers there is a problem when it converts to csv its truncated to the exponent.
ie in Excel
1234567891234670
becomes
in CSV
1.23457E+15
I have tried formatting it in the CSV file but thats not working
Is there a way around this?
I have tried to save my excel spreadsheet as a csv file, however, in the columns where I have very long numbers there is a problem when it converts to csv its truncated to the exponent.
ie in Excel
1234567891234670
becomes
in CSV
1.23457E+15
I have tried formatting it in the CSV file but thats not working
Is there a way around this?