This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Date Formats to default 00-Jan-00 in a correctly formatted cell (14-Mar-12) - HELP!!!
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 79%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERA%3C/text%3E%3C/svg%3E)
File - Options _Advanced, make sure the Transition Formula entry option is not checked in the Lotus compatibility section:
How in the world does a Lotus compatibility feature impact an Excel sheet that's never (to my knowledge) been associated with Lotus?
Well, we have seen these problems from time to time here in the forum, there are programmers (mostly from AddIns) who play around with these settings... for what reason ever.
I'm glad we were able to help, thanks Rory for the good idea, I wouldn't have had it.
Andreas.
Well, dang, that worked! How in the world does a Lotus compatibility feature impact an Excel sheet that's never (to my knowledge) been associated with Lotus? Thanks Rory!!!
No, I've entered a date, such as today's, 2/7/24 which turns into =2/7/24 upon pressing Enter!
A date format just means how the number in the cell should be shown, that's all. In your case you have a 0 in the cell.
Andreas.