4 Simple Methods To Convert Scientific Notation Into Numbers
Рет қаралды 7,038
Күн бұрын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: kzfaq.info...
#Excel #ExcelTips #ExcelTutorial
@trumpexcel 5 ай бұрын
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 5 ай бұрын
Sumit- thank you for sharing your knowledge. I truly appreciate your efforts. 🙏
@trumpexcel 5 ай бұрын
Thanks for the kind words... Glad you found the video useful 🙂
@rawwiser 5 ай бұрын
Your all tutorials are useful
@bosswavegaming8536 3 ай бұрын
Thank you very much! Exactly what I needed!
@trumpexcel 3 ай бұрын
Glad you found the video helpful 🙂
@IvanCortinas_ES 5 ай бұрын
A very useful tutorial. Thank you Sumit!!
@trumpexcel 5 ай бұрын
Thanks Iván... Glad you found the video useful 🙂
@asmrindia 5 ай бұрын
Very Useful Sir Thanks
@SK7_8_6 5 ай бұрын
Good information 👍
@trumpexcel 5 ай бұрын
Glad you found the video useful 🙂
@anasahmad5415 5 ай бұрын
Hi I am requesting this alot cab you bring courses related to powerbi ? Especially DAX please
@trumpexcel 5 ай бұрын
I will make videos on POwer BI. I am not sure about DAX as I don't use these
@vmr8974 5 ай бұрын
Excellent
@vamaveche09 5 ай бұрын
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 5 ай бұрын
Yeah, that's a weird issue Excel has. Apostrophe is the only way I know to solve that.
@masumraja3827 5 ай бұрын
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 5 ай бұрын
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
@michaellundsrensen2292 5 ай бұрын
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 5 ай бұрын
Have a look at this - trumpexcel.com/convert-text-to-numbers-excel/
@michaellundsrensen2292 5 ай бұрын
@@trumpexcel Thanks! Your option 4 is exactly what I'm doing!
@sabduljabbar5026 5 ай бұрын
Sir Could u please tell how to convert scientific Notation to Number format in power Query?
@aakankshasharma2244 4 ай бұрын
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
@alexb9312 5 ай бұрын
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.
@kanishks069 5 ай бұрын
Isi baat par ek video.... Personal Expense par .... Credit card Balance and expenses with emi and charges par ...... Bhi bana do
@sarfarazahmed5775 5 ай бұрын
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 5 ай бұрын
Sir Could u please tell how to convert scientific Notation to Number format in power Query?
@alexb9312 5 ай бұрын
If you don't have more than 15 digits try changing the data type to currency
TrumpExcel
Рет қаралды 11 М.
TrumpExcel
Рет қаралды 60 М.