Stop OpenOffice Writer truncating your dates

When you’re have a report due, the last thing you want OpenOffice Writer doing is maddeningly truncating your dates in tables like it’s 1999. Fortunately, after a cup of tea I realised table cells in Writer behave the same way as spreadsheet cells in Calc. By which I mean, the documentation said so.

To fix:

  1. Click on the offending 02/09/13 cell
  2. Choose “Number format…” from the Table menu
  3. Choose “31/12/1999″ from the Format listbox

I’m assuming this would work for LibreOffice too.


This is one of about 5000 posts on Rubénerd. View the home page for the latest, or related posts also tagged with:

If you liked this post, feel free to buy me a coffee, leave me a comment on Twitter, or email me at Thanks :).