Channel: TeachExcel

Category: Education

Tags: scientific notationscientific notation excelnumber formatting excel

Description: VBA/Macros Course (40% Discount): teachexcel.com/vba-course-update.php?src=youtube_v_description_F3VL7a6R51Q Excel Quickie Playlist: youtube.com/playlist?list=PLxhsXZXQXrUBRG1QskvchMBezTR9ZTWaj Excel File: teachexcel.com/excel-tutorial/convert-scientific-notation-to-numbers-in-excel_1594.html?src=yt 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 Scientific Notation (Microsoft): support.microsoft.com/en-us/office/display-numbers-in-scientific-exponential-notation-f85a96c0-18a1-4249-81c3-e934cd2aae25 Excel Courses: - VBA/Macro Course: teachexcel.com/vba-course-update.php?src=youtube_v_description_F3VL7a6R51Q - Building Professional Forms: teachexcel.com/premium-courses/68/idiot-proof-forms-in-excel?src=youtube_v_F3VL7a6R51Q - Email Course: teachexcel.com/premium-courses/96/send-emails-from-excel-course?src=youtube_v_F3VL7a6R51Q TeachExcel.com #msexcel #excelquickie #tutorial