You can stop Excel from rounding large numbers by changing the cell format from General to Number. This trick works for numbers containing 15 or less than 15 digits.

In Excel, you can format a negative number by creating a Conditional Formatting rule. Select the range of cells containing the numbers. On the Home tab, in the Styles group, click the Conditional ...

C3 is empty, so there’s nothing for Excel to do yet, but we know that if the input value is 10 numeric digits, that the format will display the value as expected. The next step is to add data ...

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 ...