Re: how do I define a date format

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.


[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]