The Number format in Microsoft Excel is quite powerful, but sometimes it will fail to work, and that’s a problem for advanced users. When this happens, Excel will not recognize values as numbers ...

Open the Excel 2010 files that holds your phone numbers. Click on the cell that you want to change into a series of numbers spread out over several columns, or click on the letter above the column ...