Sheet - Date Entry/Format

When entering a date the format appears to have to be in mm/dd/yy format, even if you set the display format as dd/mm/yy or dd-mmm-yy. Very confusing, and not standard for most countries. Can this be changed?