Forums
New posts
Articles
Product Reviews
Policies
FAQ
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Menu
Log in
Register
Install the app
Install
Forums
Apple Computing Products:
macOS - Apps and Programs
4-digit year date format in Excel 2015
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="rucana" data-source="post: 1726549" data-attributes="member: 381258"><p>it does not matter the inversion of the day x month, @pigoo3. The problem relates to the year format. I can only enter mm/dd/yy instead of mm/dd/yyyy...</p><p>Every time I enter a date it becomes immediately a 2-digit year date. It sucks! As I said both the short and the middle dates formats on my system preferences are set to yyyy! I just don't what to do other than use Custom or Text...</p></blockquote><p></p>
[QUOTE="rucana, post: 1726549, member: 381258"] it does not matter the inversion of the day x month, @pigoo3. The problem relates to the year format. I can only enter mm/dd/yy instead of mm/dd/yyyy... Every time I enter a date it becomes immediately a 2-digit year date. It sucks! As I said both the short and the middle dates formats on my system preferences are set to yyyy! I just don't what to do other than use Custom or Text... [/QUOTE]
Verification
Name this item. 🍎
Post reply
Forums
Apple Computing Products:
macOS - Apps and Programs
4-digit year date format in Excel 2015
Top
