Live Interactive Virtual LearningLive interactive virtual classes are available for our public scheduled courses as well as group or in-house training requests.Experience training in the comfort of your home or office! |
![]() |
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.