cppit
Reputation: 4564
excel shows numbers truncated instead of full format
I am trying to export an excel file to csv and it exports this number : 680001010091945 as : 6.8E+14 how do I make it display the full number instead of a truncated one ? any help ? thank you
Upvotes: 0
Views: 481
Answers (1)
Related Questions
- How to prevent automatic truncation of leading zeros in Excel cell
- How to prevent excel from truncating numbers in a CSV file?
- R truncates numbers from Excel
- Excel not showing correct decimals
- Excel Opens CSV Files and Truncates Decimals to Significant Digits
- Excel is ruining my numbers with leading zeros
- Cell displays wrong number value
- Number does not display in Excel
- Some but not all Excel numbers show as a date