Date format

Closed
imran - Nov 6, 2014 at 02:12 AM
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)

Related: