Why does excel show e 11

Click here to join today! JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding. Solved: why do numbers show up as 6. Thread starter tjamnz Start date Sep 18, Status This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site. Joined Jun 15, Messages Hello, I was wondering why numbers show up that way and what it generally means.

I can double click each cell in the column and it will show the real number i need, such as: Is there a way to convert the whole row, so the numbers will show normally. Joined Jul 20, Messages 4, Select "Format Cells" and "General" as the format. Zack Barresse. Joined Jul 25, Messages 5, Hi there, Generally it is because the column is too thin for the data to show correctly or a standard number format is not specified - or even that scientific notation is specified.

Excel is only precise to 15 digits. I would recommend formatting as Number. Firefytr was it you whom posted that formatting it as text is a work around for the 15 character limit? I read a post yesterday or the other day to that extent. Office ProPlus is being renamed to Microsoft Apps for enterprise.

For more information about this change, read this blog post. After you enter a long number such as a credit card number in an Excel cell, the number is not displayed correctly in Excel. For example,. On the Number tab, select Text , and then click OK. If you do not want to see the warning arrows, click the small arrow, and then click Ignore Error.

When you enter a long number, type a single quotation mark ' first in the cell, and then type the long number. For example, type ' and the quotation mark will not be displayed after you press ENTER.

Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Learn more. Turn off scientific notation in Excel Ask Question. Asked 9 years, 3 months ago. Active 5 months ago. Viewed k times. Improve this question. VBwhatnow 2, 1 1 gold badge 16 16 silver badges 22 22 bronze badges.

Pierre Gardin Pierre Gardin 1, 2 2 gold badges 9 9 silver badges 10 10 bronze badges. Possibly relevant if you're importing a file: How can you make Excel stop formatting large numbers as scientific notation? Another possibly relevant question: Why does Excel treat long numeric strings as scientific notation even after changing cell format to text — Bob. And if you actually need to work with large numbers, there's an add-in, as mentioned an answer to in this question: Why is Excel truncating my digit numbers?

Add a comment. Active Oldest Votes. Unfortunately excel does not allow you to turn this functionality off by default. Improve this answer.

VBwhatnow VBwhatnow 2, 1 1 gold badge 16 16 silver badges 22 22 bronze badges. I would argue that your modification to the question changes its meaning. Excel only accepts numerical data up to a certain precision, so there's a distinction between storing as text essentially unlimited precision, but difficult to manipulate and storing as a number. The original question did ask how to store as text by default. And then there's how the imprecise? You are right when you say that if the asker wants to actually store as text my answer would be incorrect.

He can clarify later if my answer is not satisfactory and we can look at other solutions. Please note that while saving your file it goes back to same scientific notation. Keep in mind however that if there are more than 15 digits in the number excel will convert the digits at the end to "0" Seriously