Jump to content


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.

Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.


Office 365 - Excel date formatting

  • Please log in to reply
No replies to this topic

#1 w411


  • Members
  • 66 posts
  • Local time:12:28 PM

Posted 14 December 2013 - 01:29 AM

In previous versions of Excel if I have a column formatted for any date format, if I type in a 3 letter month code and the date (ie dec 16) the date is automatically formatted as December 16, 2013.


I just tried in Office 365 and it changes the date to December 1, 2016, dec 15 gets converted to December 1, 2015 etc.


Anyone have any idea how to get the shortcut functionality back, or if it is even possible?

BC AdBot (Login to Remove)


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users