Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

It does not say where you are from in the profile settings, but for my locale (en-us), it works like this.

Select cell A1 and press CTRL+1 to show these format settings.

format cells

Now enter 3/13/17 to produce this result.

2017-03-13

What needs to be entered varies according to the Date acceptance patterns specified at Tools -> Options -> Language Settings -> Languages.