Re: how do I define a date format

[Henry Proudhon <henry proudhon insa-lyon fr>]

> dd/mm/yyyy is already a predefined format, I do not understand why you
> need to create a new one.
>  
I don't have it in my date-format list, though d-mmm-yyyy is present.
But entering the custom format as suggested by Hal work well for me 
(gnumeric-1.6.1).

> 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).
>  
I agree, the thing is once you've typed 05/12/2005, gnumeric interpret 
that as mm-dd-yyyy which is perfectly rigth with my locale (en_CA).
The workaround can be to pre-format the empty cells with the custom 
dd/mm/year. Then if you type 31/12/2005 and change to d-mmm-year you 
have 31-Dec-2005.

Henry