4 Simple Methods To Convert Scientific Notation Into Numbers

When you're working with long numbers in Excel, sometimes you would notice that Excel converts long numbers into scientific notations such as (12.3E + 12)
In this video, I have covered some methods you can use to quickly convert these scientific notations back into numbers in Excel.
00:00 Intro
00:16 Changing Cell Format
01:34 Changing Column Width
02:28 Adding Apostrophe Before Numbers
05:00 Using Text Formulas
Read the article - trumpexcel.com/convert-scient...
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
✅ Free Dashboard Course - bit.ly/free-excel-dashboard-c...
✅ Free VBA course - bit.ly/excel-vba-course
✅ Free Power Query Course - bit.ly/power-query-course
✅ Best Excel Books: trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: kzbin.info...
#Excel #ExcelTips #ExcelTutorial

[@trumpexcel]

If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what Excel topics you want me to cover in future videos. Also, I have made all of my Excel courses available for free. You can check these out using the below links: ✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/ ✅ Free Dashboard Course - bit.ly/free-excel-dashboard-course ✅ Free VBA course - bit.ly/excel-vba-course ✅ Free Power Query Course - bit.ly/power-query-course

[@paintingangel]

Sumit- thank you for sharing your knowledge. I truly appreciate your efforts. 🙏

[@trumpexcel]

Thanks for the kind words... Glad you found the video useful 🙂

[@rawwiser]

Your all tutorials are useful

[@bosswavegaming8536]

Thank you very much! Exactly what I needed!

[@trumpexcel]

Glad you found the video helpful 🙂

[@IvanCortinas_ES]

A very useful tutorial. Thank you Sumit!!

[@trumpexcel]

Thanks Iván... Glad you found the video useful 🙂

[@asmrindia]

Very Useful Sir Thanks

[@anasahmad5415]

Hi I am requesting this alot cab you bring courses related to powerbi ? Especially DAX please

[@trumpexcel]

I will make videos on POwer BI. I am not sure about DAX as I don't use these

[@Sohrab999]

Good information 👍

[@trumpexcel]

Glad you found the video useful 🙂

[@vmr8974]

Excellent

[@vamaveche09]

The apostrophe perfect an easy thing I did not know, I was struggling with "e" at the end of numbers like in ex. 2583e2 always giving me 2.58E+05 and it reads 25800, with the apostrophe the correct number should be 2583e2. Thx Sumit.

[@trumpexcel]

Yeah, that's a weird issue Excel has. Apostrophe is the only way I know to solve that.

[@masumraja3827]

Sumit Sir....Please make your blog videos also....make another channel for blogging if possible......as like you visited Global excel summit and met the legends of Excel i.e Chandoo...Leila Gharani...etc...It will help us too..... -Thanks Masum

[@trumpexcel]

Thanks for commenting Masum... I plan to focus on my Excel only for now. But I will surely consider making more videos about blogging in the future

[@kanishks069]

Isi baat par ek video.... Personal Expense par .... Credit card Balance and expenses with emi and charges par ...... Bhi bana do

[@sabduljabbar5026]

Sir Could u please tell how to convert scientific Notation to Number format in power Query?

[@aakankshasharma2244]

Sir i an working on data where i need to apply concate function on two numbers, that results in number with 15 digits… after that i apply paste special to convert the result in number.. but excel convert that into scientific… what should I do to elemenate this

[@michaellundsrensen2292]

Thanks! Easy to understand. Sometimes when I import numbers from other equipment they end up as text without the apostrophe. How can I easily change these text numbers to real numbers? Format the cell can't do that. Instead, I write a 1 number in an empty cell and copy it. Then I use Insert Special and multiply the text number by the number in the clipboard and get the correct number. Can you tell me an easier way to do it?

[@trumpexcel]

Have a look at this - trumpexcel.com/convert-text-to-numbers-excel/

[@michaellundsrensen2292]

@@trumpexcel Thanks! Your option 4 is exactly what I'm doing!

[@alexb9312]

Should you find that you are manually entering long numbers, formatting the column as text before you start entering the numbers is more efficient than manually entering an apostrophe before every entry and achieves the same result.

[@sarfarazahmed5775]

Sir jab hum calculation with text k sath karty hen through ctrl+1 k sath, or agar aik he column mai different multiple item hon with text text. Like 1, minute, hour, gram , kg, etc. Tu hum aik aik cell mai ja k control+1 kar k her cell mai bar bar her aik text k liye type karna parta hai. Es ka koi solution batain k ya tu format cell option mai ja ka aik bar he kise tareqy sy value type karlain ya dropdown ban jaye ta k bar bar aik he column mai her cell mai formatting na karni pary. Thank You Sarfaraz from Pakistan

[@sabduljabbar5026]

Sir Could u please tell how to convert scientific Notation to Number format in power Query?

[@alexb9312]

If you don't have more than 15 digits try changing the data type to currency