How can I set the default Date format in OpenOffice Spreadsheet?

Answer 1

I recommend you set the DATE format by selecting the cells containing the date, choosing Format Cells, and selecting the format you want - the format you choose becomes the default for the cells you've selected.