I'm new to Open Office, and I've opened up an excel file (no macros) one column of which is date formatted to DD/MM/YYYY, my problem is that I've inserted a date 26/05/2005 but when I move to the next column or row this date alters to 1 day less ?, ie 25/05/2005 albeit the data input field at the top of the screen still shows the correct details, and I can't find how to correct this.
Clive