FG
💻 Software

Excel 2007 is converting CSV fields into formulas

Fresh7 days ago
Mar 15, 20267242 views
Confidence Score0%
0%

Problem

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…

Error Output

Number,Name
+1-800-555-1234,Bob
+1-800-555-1200,Jim

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: Excel 2007 is converting CSV fields into formulas

Low Risk

Open a blank worksheet then select 'Data > Get External Data > From Text' (Excel 2007 menu layout). Then when you open your CSV file you'll get the 'Text Import Wizard' which will allow you to specify particular columns as Text instead of the defaul…

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment