excel is changing date format

H

hubbo

In regional settings I have short date = yyyy-MM-dd.
When I type any date for example 2005-05-18 excel
change it to 18-05-05.

How can I fix this
 
B

Barb R.

Format -> Cells -> Date -> Locale - English (United States) and select the
format you want.
 
Top