Channel: TeachExcel

Category: Education

Tags: macro recorder formattingnumber formatting with macrosexcel number formattingvba number formatting

Description: Excel VBA Quickie Playlist: youtube.com/playlist?list=PLxhsXZXQXrUDjjYmKn5Wi3V6dkyjGpV9q Excel Forum: teachexcel.com/talk/microsoft-office?src=yt Quick tip for getting the code for Number Formatting in VBA/Macros correct for Excel. This tip shows you how to avoid remembering the complex long number formats that Excel uses and it also shows you how to make it as easy as possible by automatically generating most of the required code. In addition to the basic number formatting trick, I show you how to easily update and change range and worksheet references in VBA so you can more dynamically apply your number formatting using a macro in Excel. Enjoy! Excel Courses: - VBA/Macro Course: teachexcel.com/vba-course-update.php - Building Professional Forms: teachexcel.com/premium-courses/68/idiot-proof-forms-in-excel?src=youtube_v_D-_VcWmJeoU - Email Course: teachexcel.com/premium-courses/96/send-emails-from-excel-course?src=youtube_v_D-_VcWmJeoU TeachExcel.com #msexcel #excelquickie #tutorial