The Scientific format displays a number in exponential notation, replacing part of the number with E+n, in which E (exponent) multiplies the preceding number by 10 to the nth power. For example, a 2-decimal scientific format displays 12345678901 as 1.23E+10, which …

Use a formula to convert from text to numbers. You can use the VALUE function to return just the numeric value of the text. Insert a new column next to the cells with text. In this example, column E contains the text stored as numbers. Column F is the new column.

In Excel, you can format numbers in cells for things like currency, percentages, decimals, dates, phone numbers, or social security numbers. Select a cell or a cell range. On the Home tab, select Number from the drop-down.

You can use the built-in number formats in Excel as is, or you can create your own custom number formats to change the appearance of numbers, dates, and times.

Create a custom number format. Convert dates stored as text to dates. Fix text-formatted numbers by applying a number format. Available number formats in Excel Online. Format numbers to keep leading zeros in Excel Online. Format numbers as text

Excel provides a special number format that lets you format a number as a phone number. For example, you can format a 10-digit number, such as 5555551234, as (555) 555-1234. To see the number format code for the Phone Number format, click …

You'll probably want to change the format to numbers otherwise it can cause errors in calculations or sorting. Here's how you can change the format to Number: Select the cells that have the data you want to reformat. Click Number Format > Number.

The General number format also uses scientific (exponential) notation for large numbers (12 or more digits). Select the cell or range of cells that you want to reformat to the default number format. How to select a cell or a range

For example, because computers use Boolean logic to perform calculations and operations, they use the binary number system, which has a base value of 2. Microsoft Office Excel has several functions that you can use to convert numbers to and from the following number systems:

To create a custom number format, you start by selecting one of the built-in number formats as a starting point. You can then change any one of the code sections of that format to create your own custom number format.