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