Re: how do I define a date format

[Jean Bréfort <jean brefort normalesup org>]

Le lundi 05 décembre 2005 à 17:21 +1100, Rod Butcher a écrit :
> Harald Richard Ashburner wrote:
> > Rod Butcher said:
> >
> > > Greetings gnumericsters from Sydney. I need to work with spreadsheets 
> > > which have a date column I can sort the entries by. I use dd/mm/ccyy for 
> > > date format e.g. 31/12/2005. I haven't managed to define this in 
> > > gnumeric for data entry or valiodation.
> > > I went to format cells - date but couldn't find a way to define a new 
> > > date format.
> > > I tried defining it just as custom. But couldn't find a way to specify 
> > > edit rules for the new "custom" cell rule.
> > > Is dd/mm/ccyy currently not possible, or am I just a klutz ?
> >
> >
> > Format->cells
> > select 'Custom' in the pane on the left.
> > Next to 'Format code:' delete "General" (or whatever is there)
> > and type 'dd/mm/yyyy' (without the ' quotes)
> But then I get "dd/mm/yyyy is not true" when I try to enter a date. ??
> > Done.
> > HTH

dd/mm/yyyy is already a predefined format, I do not understand why you
need to create a new one.
To enter a date, just type 05/12/2005, it should work (at least it works
for me), but this might be locale dependent (gnumeric might interpret
this date as May 12th).

Best regards,
Jean