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 - https://trumpexcel.com/convert-scient...
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - https://www.buymeacoffee.com/SumitB
✅ Free Excel Course (Basic to Advanced) - https://trumpexcel.com/learn-excel/
✅ Free Dashboard Course - https://bit.ly/free-excel-dashboard-c...
✅ Free VBA course - https://bit.ly/excel-vba-course
✅ Free Power Query Course - https://bit.ly/power-query-course
✅ Best Excel Books: https://trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexc...
#Excel #ExcelTips #ExcelTutorial
Watch video 4 Simple Methods To Convert Scientific Notation Into Numbers online without registration, duration hours minute second in high quality. This video was added by user TrumpExcel 08 February 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 9,660 once and liked it 231 people.