4 Ways To Fix Your Power Query Date Errors Locale
Excel Campus - Jon
@excelcampusAbout
Excel Campus is here to help you learn Excel and save you time with your everyday tasks. My name is Jon Acampora and my goal is to help you improve your Excel skills. This channel contains "how-to" tutorial style videos on a wide range of Excel topics including: formulas, pivot tables, macros, VBA, charts, dashboards, Power Query, Power Pivot, Power BI, and much more. I want to hear from you and learn about what you are struggling with in Excel. Please visit my website and subscribe to my free email newsletter. http://www.excelcampus.com/newsletter/ And don't forget to subscribe to our YouTube channel. Thank you!
Latest Posts
Video Description
Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/ Learn how to fix date errors in Power Query. The video covers four different ways including: 1. Adjusting the locale for individual columns. 2. Changing the regional settings for the entire file. 3. Changing the regional settings on your operating system. 4. Using the “Columns From Examples” feature to decipher the correct formatting and apply it to your query. If you’d like to read the corresponding blog post for this video on my website, you can find it here: https://www.excelcampus.com/powerquery/power-query-date-errors-settings Related Videos: Convert Text to Time Values with Power Query: https://www.youtube.com/watch?v=1h94nq4if28 How to Install Power Query in Excel 2010 or 2013 for Windows: https://www.youtube.com/watch?v=gwW2CDdvUUs How to Unpivot Data with Power Query in Excel: https://www.youtube.com/watch?v=Kbu5RkUo6-k Preview of PowerQuery, Pivot Tables, and Dashboards Video Series: https://www.youtube.com/watch?v=WYfIgthJjFE #MsExcel #ExcelCampus 00:00 Introduction 00:57 Local Settings 02:16 Regional Setting 04:30 Changing Regional Settings 06:40 Convert Dates
You May Also Like
Kitchen Essentials for Quick Meals
AI-recommended products based on this video
Lemon Squeezer, 2025 New Screw-Top Lemon Squeezer Manual Juice Extractor with Built-In Filter Orange Citrus Press, Squeeze Lime for Cocktails, Drinks
2025 New Screw-Top Lemon Squeezer,Fast Juicing, Portable Manual Citrus Juicer, Orange Extractor with Lid, Squeeze Lime for Cocktails, Drinks (yellow and green)
Liahelianx Mini Citrus Press - Handheld Lemon & Lime Juicer with Screw Top Lid, Compact Manual Juice Extractor for Cocktails, Drinks, Kitchen - Durable, Easy Clean, Portable Fruit Squeezer
Ultra-Slim Bidet Attachment, Posterior&Feminine Wash-(Retractable Dual Nozzles), Non-Electric Bidet Attachment for Toilet Seat, Adjustable Fresh Cold Water Pressure, Stainless Steel Inlet (White)
Ultra-Slim Bidet Attachment, Posterior&Feminine Wash-(Retractable Dual Nozzles), Non-Electric Bidet Attachment for Toilet Seat, Adjustable Fresh Cold Water Pressure, Stainless Steel Inlet (White)
TRAUSI Instant Read Meat Thermometer, Fast & Accurate Digital Food Thermometer with Backlight, Waterproof & Magnet for Grilling, Cooking, BBQ, Smoker, Baking, and Candy Making Black
