Convert Scientific Notation to Numbers in Excel (3 Ways) - EQ 97

3 ways to convert scientific notation to regular numbers in order to show their full amount; this method also allows you to retain the appearance of text in case you have a mixed list of text and numbers in scientific notation format.

There are a number of ways to do this and what you should use depends on your dataset.

Additional Resources

Excel Courses:

#msexcel #excelquickie #tutorial

[simonepagnotta]

Thank you! Solution number 2 was exactly what I needed.

[MA-jcms]

Awesome 👍
This is what I'm talking about
A practical and easy solution in a short period of time

Well done 👍

[tusharkhanjodkar]

Resolved my concern for assessment given for interview, Thanks a lot sir.. Keep posting more videos

[jamielee]

If u noticed, this method changes all first/single digit to the number '0'. Not exactly the best way if u want to preserve the every single number

[sitotaw]

But is still remains the same when you open it after saving.

[happymullick]

I have 25+ numbers, then how to convert same

[nlg]

I just tried all three methods and non of them worked. Any suggestions?

[faisalmalik]

I have a question.. In Notepad the number is 123456789898 and when I open this into excel 123456789800....it automatically removed last two original number which was "98" and added "00" at the end. how can be find out these issue can anyone help on this

[praveene]

Try entering 20 digits without including zero. You won't get any numbers after 15 digits but zeros. This video is waste.