For a Limited Period!
Buy 2 ~ Free 1 pax OR Get 30% off for every pax on our scheduled classesAnalyzing Data with Power BI Microsoft Excel - Power Query (M365, 2021-2010) Microsoft Excel - Power Pivot (M365, 2021-2010) Please This email address is being protected from spambots. You need JavaScript enabled to view it. for more info. |
![]() |
Overcoming common problems - Date
Getting wrong date formats when entering a date? Let's say you entered 1st April 2010 in excel, but upon pressing the Enter key the date shows 4th January 2010 instead. This is because the window setup for dates is in the American date sytle. To correct this, go to the control panel and change the date setting to dd/mm/yy ie day/month/year format.