excel truncating phone number
- by user15586
I have a csv file that contains cells such as "+1.8882789780".
When viewed in Excel, it loses the last digit possibly due to excel truncation.
Is there a way to either change the setting in Excel to prevent this from happening or change the csv file in some way?
One way is to wrap single quotes around the cell contents in addition to the double quotes.
"'+1.8882789780'"
Is there a better way?