Back to Browse

Easy Date Conversion with VBA - Excel VBA Quickie 6

14.3K views
Feb 4, 2021
4:17

VBA to easily convert dates seen as text into formatted date types in Excel, especially when going between USA & World Date formats. VBA/Macro Course: https://www.teachexcel.com/vba-course-update.php Excel File: https://www.teachexcel.com/excel-tutorial/2398/easy-date-conversion-with-vba?nav=yt Excel Forum: https://www.teachexcel.com/talk/microsoft-office?src=yt Excel VBA Quickie Playlist: https://www.youtube.com/playlist?list=PLxhsXZXQXrUDjjYmKn5Wi3V6dkyjGpV9q This issue is a real problem when importing Text or CSV files into Excel, especially if your system uses non-USA formats for dates or you are working with data sets that have mixed date formats. This tutorial shares a small piece of VBA that will help you to convert your dates into the correct format in Excel, whichever format that is for you. Excel Courses: - VBA/Macro Course: https://www.teachexcel.com/vba-course-update.php - Building Professional Forms: https://www.teachexcel.com/premium-courses/68/idiot-proof-forms-in-excel?src=youtube_v_lK0FaBDchqU TeachExcel.com #msexcel #excelquickie #vba

Download

0 formats

No download links available.

Easy Date Conversion with VBA - Excel VBA Quickie 6 | NatokHD