Forum Discussion
Date format changes
Date format changes from dd/mm/yyyy to mm/dd/yyyy when using csv conversion for day less than 13. Seems input changes from text to number when day is less than 13. This is a recent fault, within the ...
Thank you for your response, I'm afraid all I get when I choose "File">"Option" is "Regional Format Settings" , there are no other options or side bars. When selected a new dialogue box opens showing "English (United Kingdom)" all it does is show an international list of other regional settings.
I have tried using under "Number" the "General" section selecting the date format dd/mm/yyyy and even using "Custom" and then "Date" to set the same format to no avail. There is no problem with the wanted date format for dates with days larger than 12, its when the day is below 13 the format changes unexpectedly.
fgwall3gmailcomwhen you say that you only have this problem when the date number is larger than 12, is because you have the issue always, is just that you don't notice because the excel is identifying what you write inverting the month with the day, so if you put, for example, 01/12/1990 (january first) the excel think you are writing 12 of december. I have the same problem, that could be "solved" changing the regional settings but I don't want to do that because my keyboard is for US language and if I change the regional setting, my keys won't work correctly. I would only like to change the date configuration, if possible.
