Whenever you type a number into Excel that contains more than 11 digits, Excel will automatically format the number using scientific notation with **E+11** displayed at the end of the number.

The easiest way to convert scientific notation to text is to use the **TEXT** function with the following formula:

=TEXT(A1, "0")

This particular formula will convert the number displayed with scientific notation in cell **A1** to text.

The following example shows how to use this formula in practice.

**Example: How to Convert Scientific Notation to Text in Excel**

Suppose we type **123456789111** into Excel:

Excel formats the number using scientific notation as **1.23457E+11** since this number contains 12 digits.

To convert this number from scientific notation to text, we can type the following formula into cell **B1**:

=TEXT(A1, "0")

The following screenshot shows how to use this formula in practice:

This formula uses the **TEXT** function with the argument “0” to format the number in cell **A1** in such a way that all digits are displayed.

We have now successfully converted the number in scientific notation in cell **A1** into text in cell **B1**.

**Note**: You can find the complete documentation for the **TEXT** function in Excel here.

**Additional Resources**

The following tutorials explain how to perform other common operations in Excel:

How to Round to Significant Figures in Excel

How to Remove Digits After Decimal in Excel

How to Convert a Fraction to a Decimal in Excel