On 09/06/2007 01:25 PM, Clive Bowley wrote: > > ----- Original Message ----- > From: "NoOp" <[EMAIL PROTECTED]> > Newsgroups: gmane.comp.openoffice.questions > Cc: <[EMAIL PROTECTED]> > Sent: Thursday, September 06, 2007 6:03 PM > Subject: Re: Date format > > >> On 07/05/2007 03:11 AM, Clive Bowley wrote: >>> 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 >> >> I'm unsure of what you mean by "move to the next column or row". Are you >> referring to selecting the next column or row (using mouse, tab, arrow >> key), or moving the data in the cell to another column or row? >> >> Please reply only to users@openoffice.org >> >> > It was using the tab /mouse, not transferring any data > regards > Clive
That's rather odd & I cannot seem to replicate it. Is it possible that you'd be willing to chop out any sensitive stuff on the worksheet and post here or send to me directly? (glgxg at sbcglobal.net). --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]