![]() ![]() In such cases, use the method covered before (by changing cell formatting) Convert Scientific Notation to Text in Excel Any number that is longer than 11 digits would anyway be shown in the scientific notation, so adjusting the column width won’t help. Note that this would work only for numbers that are 11 digits or less. If you increase the column width enough to show the whole number, you’ll see that it will solve the problem. This can happen if the column width is not wide enough to show the entire number, so Excel tries to adjust the column width by showing that number in the scientific notation. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |