I have a problem with a CSV file which has telephone numbers stored in their internationalized format (+1-800-555-1234). When opening this CSV in Excel 2007, it converts that data to a formula and displays the result (=1-800-555-1234; resulting in -2588).
How do I tell Excel to handle this field as a string?
Here is a sample - save this in to a .csv file and open in Excel reproduce the issue:
Number,Name +1-800-555-1234,Bob +1-800-555-1200,Jim