In my locale, date is inserted as dd/mm/yyyy or variations of that (including dd-mm-yy). I made an Excel form (in normal Excel file), already formatted to show date as dd/mm/yyyy, but when I typed "05/04/2015" it will be shown as "04/05/2015". I know this can be solved by changing the regional setting to my local setting, but I need to distribute this form to a lot of people with no knowledge of changing regional setting, and assuming no one can teach how to, hence my question :
Is there any way to input "05/04/2015" and be recognized as "5 April 2015", without having to change regional settings ?
Additional note: When I mean "4 May 15" (typed in 4/5/15), Excel will recognize this as "5 April 15" because Excel takes input as "mm/dd/yy" format. I need to change the default behavior of Excel to take as "dd/mm/yyyy" as this is the way the users will input.
If possible, the setting should also included/embedded on the file to allow end-users use the form without even changing setting.
I'm not familiar with macros and VBA, but willing to try those :)
EDIT : this is related to my question : How to change date format from dd-mm-yyyy to dd-mm-yy in formula bar of MS-EXCEL?
but I don't need to change the whole formula bar, as long as Excel recognize that I'm typing in dd/mm/yy format.