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:
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:
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.
The following tutorials explain how to perform other common operations in Excel: