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
--
hubbo
Format -> Cells -> Date -> Locale - English (United States) and select the
format you want.
> 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?