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 _______________________________________________ gnumeric-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnumeric-list
