Date format

[Closed]
Report
-
hello,

i ve an excel sheet and want to enter date in format dd/mm/yy, but cell automatically change it and treat as mm/dd/yy, i want excel treat it as date as my entered format(dd/mm/yy)