excel truncating phone number

Posted by user15586 on Super User See other posts from Super User or by user15586
Published on 2012-09-22T22:15:17Z Indexed on 2012/09/23 15:40 UTC
Read the original article Hit count: 258

Filed under:
|

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?

© Super User or respective owner

Related posts about microsoft-excel

Related posts about csv