[Solved] Suddenly dates do not display correctly

[bobfleming]

Suddenly, a couple of weeks ago, many dates on one of my spreadsheets do not display properly. The cells are formatted for a date to display as Dec. 31, 1999 and this has worked without a problem for years, but now new dates added after May 5, 2017 display on screen as ###. If I double-click on one of those cells, the date displays correctly, but as soon as I leave that cell the date reverts to ###. If I print the spreadsheet, all the dates display properly, like May 23, 2017. I suspected a corrupted program so I uninstalled Open Office and reinstalled it, but the problem persists. What is causing this weird problem and how do I fix it?

[acknak]

The ### on the screen means that the column is too narrow to display the entire formatted value.

Select the column(s) and drag the vertical dividing line/border to make the column wider.

[bobfleming]

Thank you. That was the problem. Apparently I accidentally and unknowingly narrowed the column during an errant mouse move! And I spent many hours and reinstalling open office on two computers and then it took a couple of seconds to fix it from your suggestion! This problem is resolved but I don't know how to indicate that on the site.

[robleyd]

How to tag a topic as solved.

In your first post, click the Edit button. Go to the subject line and add [Solved] at the beginning of the subject.

Then select the tick as the Post icon (just below the subject line). Preview if you wish to see how it looks.
Finally, hit Submit - done!