Ask Your Question

i'm using date format yyyy/mm/dd. how do i get "2017/03/13"?

asked 2018-04-01 13:37:45 +0200

janebobh gravatar image

I'm using date format: 1999-12-31. What do I type in to get: 2017-03-13?

edit retag flag offensive close merge delete



First: your question title (using / as date parts separator) differs from body of question (referring to - as separator).

Second: if you use the date format mentioned in title, then you will get the wanted (in title) result automatically.

Mike Kaganski gravatar imageMike Kaganski ( 2018-04-01 17:57:34 +0200 )edit

The title should be a summary of the question, and then provide more details in the question body. See guidelines for asking.

Jim K gravatar imageJim K ( 2018-04-02 17:07:42 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-04-02 17:05:21 +0200

Jim K gravatar image

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.


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

edit flag offensive delete link more


Direct input of an ISO date like 2017-03-13 is accepted in every locale, independent of current date acceptance patterns, and automatically applies the ISO date format. It is not necessary to pre-format the cell with the ISO format.

erAck gravatar imageerAck ( 2018-04-04 16:12:26 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-04-01 13:37:45 +0200

Seen: 180 times

Last updated: Apr 02 '18