Hi Tachyon
Thank you for your answer. I tried to set these regional settings via ctrl panel. Unfortunately despite several reboots the date format is still the same MM/DD/YY. It seems like the ctrl panel has stopped working. At one point it said the entries were corrupt and i would have to reinstall windows. Could localtime or gmtime functions override operating system date formats and keyboard layout or is it more likely caused by messing with excel and