Why is my number stored as text in Excel? Excel doesn’t convert numbers written in text into digits if you import data from another source because of the default setting.

If your data includes inconsistent types, such as numbers mixed with text in the same column, this automatic step can cause ‘DataFormat.Error: We couldn’t convert to Number’.

SEE: 83 Excel tips every user should master (TechRepublic) In this Microsoft Excel tutorial, I’ll show you four easy ways to convert numbers stored as text to real numbers.

Got a problem with an Excel spreadsheet. I have a non-specific data column in an Excel 2007 spreadsheet. The data in one column is zip codes in the form of both zip (5 digit, 00000) and zip+4 (10 ...